Query : age group by location

[Will04]

hi everyone,

I have a table with persons age and location and I want to generate a report of all persons by location and age group. The age groups are 0-9, 10 - 19, 20 - 29..., 90-99.
The location codes are 10,20,30,...90,99.

Any suggestions?

Many thanks

Will.

 

[Jon K]

You can do it with a series of two queries.
See the queries in the sample database.

Run the second query.
.

 

[Will04]

Thank You!!

Hi Jon,

Thank you so much, it worked wonderfully...


Appreciated,

Will