Well hello, Novice. Let me introduce you to your new best friend, the "Totals" query, which will allow you to crunch numbers in no time.
I'm assuming there is a field that joins the two tables together. If not, there may be a third ("Junction") table that creates the join. It would have an ID field from each table. You would add this table too, then join IDs to its matching field and SurveyCounts to its matching field.
Begin a new query in design view.
Add your ID table and your DailyCounts table and close the dialog box.
Make sure that the there is a join line connecting the common field in your ID table to the same field in your DailyTotals table.
In the ID field list, double click the Category field to add it to your query grid.
Double click the SurveyCount field to add it to the second column.
Click the "Totals" button on the toolbar, (the greek "Sigma" symbol)
A new row will appear in your query grid that will have "Group By" for both columns.
In the second column, in your query grid, change the "Group By" option to "Sum"
If you want to make the number crunchers really happy, you could add the SurveyCount field as many times as you want to and set the group by option to "MIN," MAX, AVERAGE, etc.
Save and run the query and you should have it.
Your next trick would be to check out the "Crosstab Query Wizard" which can be found by clicking Query, then the "New" button in the database window. You can't hurt anything by playing with it. If you don't like what it creates, just delete the query and go through the wizard again choosing different options.
Then, the magical Pivot Table and Pivot Chart.