create a query in design view
with the category you want to summarise the count by
e.g. ProductCategory
and the field that you want to count
e.g. ProductDescription
(when you want to know how many products are in each product category)
then on the tool bar you'll see a sort-of E - called "totals"
click on it and a new row will be added to the design grid, called "Total"
under both fields you'll see "Group By"
change the one under the field you want to count to "Count"
run the query
if you don't want to break it down by category - then just select your field
and change the total line to count
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
