Creating a query & report showing # of fields completed per Catagory

[AndieAngel]

I am trying ultimately create a report to show how many responses were obtained in each catagory of my data table. This is to help us analyze which catagories need to be used next year and which ones to delete. I was thinking there was a way to do a "count" but I can't figure it out if there is. Any help will be appreciated

 

[Presterman]

I don't know if this will answer your question but...
Make the source of your report a query which groups and counts your data. Use the totals button in the query design form.

 

[PHV]

A starting point:
SELECT catagory, Count(response) AS HowMany
FROM [your data table]
GROUP BY catagory;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244