Help with counting

[Craig]

I've never used any counting function within access before and need some
help. I have an inventory table with several fields listing all the equipment
we have. One of these fields is called GROUP. This field states which
category each item of equipment falls into. For example Pedestrian Mowers,
Fine-Turf Mowers, Tractors etc. I want to have a report or form that gives me
the total number for each equipment type. Eg Pedestrian Mowers = 6, Fine-Turf
Mowers = 12 and Tractors = 3

Any help would be appreciated
Thanks
Craig

 

[KARL DEWEY]

Use this query ---
SELECT YourTable.[Group], Count(YourTable.[Group]) AS [CountOfGroup]
FROM YourTable
GROUP BY YourTable.[Group];