Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Query Help - Again (2000)

    I have a table with Ethnicity (Eth) for each record. I need counts by Ethnicity and need them in the same query.

    This is what I need:

    Query sorted by Area (Area is the field name)
    Count of all Ethnicity by Ethnicity Group, each ethnicty has a numeric value:
    African Amer = 1
    Anglo = 2
    Hispanic = 4
    etc....

    Please Help!!! Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Count Query Help - Again (2000)

    Hi,
    If I understand you correctly, you just need a totals query grouped by Area and Ethnicity, with Ethnicity added as a field a second time but this time using the Count function rather than 'Group By'.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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