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 (Access 2000)

    I have a table with an Age for each record. I need counts by age GROUP and need them in the same query.

    This is what I need:

    Query sorted by Area (Area is the field name)
    Count of all Ages's by area for Ages 8-18
    Count of all Ages's by area for Ages 19-21
    Count of all Ages's by area for Ages 21 and over

    Please Help!!! Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Query Help (Access 2000)

    Create a query with 4 fields:
    Field1 Area
    Field2 8-18: IIf([age] Between 8 and 18,1,0)
    Field3 19-21: IIF([age] Between 19 and 21,1,0)
    Field4 >21: IIf([age] > 21,1 ,0)
    Select View | Totals and in the line Total enter
    For Field1 Group By
    For the 3 others, Sum
    Francois

Posting Permissions

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