Field Totals

[Michael Treacy]

I have a database created that has a field with many different entries in
it. Is there any way of getting a count of the number of each entry in the
field?

For example, if the field contains entries A, A, B, D, C, A, B, B, B can I
get access to give me something like: Total of A = 3; Total of B = 4; etc

Mike

[Douglas J. Steele]

You can use a Totals query. The SQL would be something like:

SELECT Field1, Count(*) AS TotalForValue
FROM MyTable
GROUP BY Field1

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Michael Treacy" <mi***@utvinternet.com> wrote in message
news:3p************@individual.net...

I have a database created that has a field with many different entries in
it. Is there any way of getting a count of the number of each entry in the
field?

For example, if the field contains entries A, A, B, D, C, A, B, B, B can I
get access to give me something like: Total of A = 3; Total of B = 4; etc

Mike