Count after grouping (2k)

Topic

New Reply

Is there a way to group by and then count the number of records in that group? I have several social security numbers that are repeated. I wanted to see exactly how many different people I have, not the count of social security numbers. Thanks for the help.

Reply | Quote

Replies

You can do this with two queries.

Design a new query. Bring in the table you need. Add the SSN field to the output section. Click on the Totals button (Greek Sigma, or funny looking capital E). Save the query.

Design another new query. Bring in the query you just saved as the record source. Add the SSN field to the output section. Click on the Totals button. Change Group By to Count. Run the query.

This is one way to get the number of unique SSNs in your table.

HTH,

Tom

Reply | Quote

Thanks so much! That did it!

Jodi

Reply | Quote