Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    Michigan City, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count after grouping (2k)

    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.

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count after grouping (2k)

    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

  3. #3
    Lounger
    Join Date
    Jun 2002
    Location
    Michigan City, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count after grouping (2k)

    Thanks so much! That did it!

    Jodi <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •