Counting entries

[Sebastian]

I want to produce a report which gives the number of each of six possible values in a single field in a table. I dont see how to do this - I assume it involves the Count.
Any help with this trivially simple query gratefully received.
Sebastian

 

[pbaldy]

Try:

SELECT FieldName, Count(FieldName) AS HowMany
FROM TableName
GROUP BY FieldName

 

[Sebastian]

Thanks. Easy when you know how!