Is it possible to count totals for unique values in a query?

[rob379]

Hi, I am new to Access and not sure how to count totals for unique values in one of my fields in a query. The field ranges from 1-99 and I would like to know how many 1s, 2s, ect. there are in that field. I could make a query for each value but I feel like there has to be a better method I don't know. Thanks for your help!



Rob

[pbaldy]

You want a separate query? Start a new query based on the first and include that field twice. Click on the Totals icon on the ribbon (looks like an "E"). Change Group By to Count for the second instance of that field and run it.

[rob379]

Thanks for the help! That's exactly what I wanted

[pbaldy]

Happy to help, and welcome to the site by the way!