Results 1 to 3 of 3
  1. #1
    aajay05 is offline Novice
    Windows 2K Access 2000
    Join Date
    Mar 2010
    Posts
    2

    Multiple count query

    I am trying to create a report that shows the number of records in age groups. I am currently using count queries to to determine the age groups and amount of records in the age group. From there I am making a report that shows the amount of records in the age group. My goal though, is to put all of the age groups and counts on one query, so that I don't have to use sub reports and simplify my data. Is there any way that I can put the age groups and counts on one query? Thanks

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    in my view the best way to do this would be:

    *one table for age groups: 3 fields - groupID, lowage, highage
    *one table for the people that have ages

    then the population of the agegroup when you enter a number for an age with new records in your 'people' table will be simple. and as a result, you can query like:

    Code:
    select distinct agegroupcount(*) as [numrecords]

     
    from ''people table''

    group by agegroup

  3. #3
    aajay05 is offline Novice
    Windows 2K Access 2000
    Join Date
    Mar 2010
    Posts
    2
    Yes. I looked up a few options and I thought the same thing. Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Count function on query
    By yousillygoose in forum Queries
    Replies: 1
    Last Post: 02-15-2010, 09:58 PM
  2. Running Count Query
    By monkey2003 in forum Queries
    Replies: 0
    Last Post: 09-21-2009, 12:24 PM
  3. using COUNT for multiple tables
    By kwalt in forum Programming
    Replies: 1
    Last Post: 02-17-2009, 04:05 PM
  4. using COUNT for multiple tables
    By kwalt in forum Queries
    Replies: 0
    Last Post: 02-17-2009, 03:06 PM
  5. Result of Count Query not known elsewhere
    By Carole in forum Access
    Replies: 1
    Last Post: 09-07-2008, 09:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums