Query Count

[Elysyn]

Hello,
I have been working on this problem for several hours now, and have searched all my references at hand to find the solution to what seems to be an extremely simple problem. I have seen several postings regarding counting in this forum, but none seem to match quite what I am looking for. I am working in Access 2002, and I am trying to run a query on a column that will contain only 1 of 3 values (1,2,or 3).

I need to get a count of each separate value. This seems to be a really basic request. I should be able to set the total to Count and put the value I want it to count in Criteria, right? The data type is a number in the table. Am I just being exceptionally dense, or is this actually harder than it intuitively seems it should be?

Thank you in advance for your help!

 

[Joe4]

Create a new query. Add the field you want to count. Add that field again. Now click on the Totals icon to add the Total row that says "Group By". Change the "Group By" total on the second field to count.

Now the query will show the total for each number. If you wish to limit it to one, add criteria to the first field.

 

[Elysyn]

Thank you.

That wasn't so hard now, was it? Now, I'm going to go play and see if I can get my date parameters to work with it and the people the numbers belong to... I might be back!

Thanks again!