Counting Totals

[jashworth]

Seems simple, yet since I am new with this data base I can't not get the results I want. I have a table with a field called age. In the field are five different values (or categories that can be entered into the field for each record in the field. All I want to do is to count how many records in that field are in each category within the field. Can someone help me to get this result. Thanks

[June7]

Sounds like an aggregate (GROUP BY) query. Or build a report and use its Sorting & Grouping features with aggregate calcs.