sum of count from same field

[amicus]

I have a field "Age" which lists individual ages. I need to count the total number of records with ages within a specific range. Ideally this needs to be in a single query so that I can run a graph of the data afterwards.

I have created separate queries for each age range: "65-69," "70-74," "75-79," "80-84," and "85Over." Then I ran a count of each, which gives me the total number of records for each individual age within that range. Now I need total number of records for that range. I can sum each range individually, but cannot run them on the same query.

Any suggestions on how to get this data? My experience with VBA is very limited. Thanks.

 

[DLB]

Now I need total number of records for that range. I can sum each range individually, but cannot run them on the same query.

Do you mean you need a query that shows the total number of records in each age range?

If you do, see the query in the database. I used an age range table for grouping the ages in the query.

 

[amicus]

Thanks. I'm going to try that and see if it will work.

 

[amicus]

I'm not sure I entirely understand how it works, but I copied the query over to my database, pointed it to the right tables and it worked! Thanks!!