Multiple count query

aajay05 · #1 03-08-2010, 04:16 AM

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

ajetrumpet · #2 03-08-2010, 06:58 AM

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 agegroup, count(*) as [numrecords]



 from ''people table''



group by agegroup;

aajay05 · #3 03-08-2010, 07:00 AM

Yes. I looked up a few options and I thought the same thing. Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count function on query	yousillygoose	Queries	1	02-15-2010 06:58 PM
Running Count Query	monkey2003	Queries	0	09-21-2009 10:24 AM
using COUNT for multiple tables	kwalt	Programming	1	02-17-2009 01:05 PM
using COUNT for multiple tables	kwalt	Queries	0	02-17-2009 12:06 PM
Result of Count Query not known elsewhere	Carole	Access	1	09-07-2008 07:39 AM