I have a form based on a query which calculates employees ages from the date of birth which in turns derives from a table. I want to be able to analise staff based on their age group, e.g number staff 16-20yrs, number staff 21-25yrs. I know how to group and count but can I create a calculation to show age groups which I can then group thereafter and what would this calculation be?
Grouping a calculated field in query
- Thread starter tinynoo
- Start date
Brianwarnock
Retired
- Local time
- Today, 08:10
- Joined
- Jun 2, 2003
- Messages
- 12,701
The Count will infacr be a sum.
Assuming that age is already calculated then
Ages10_20:sum(IIf([age]>9 and [age]<21,1))
will give you the count.
If age is being calculated in the query I think that you will have to replace age with that calculation at every point.
Brian
Assuming that age is already calculated then
Ages10_20:sum(IIf([age]>9 and [age]<21,1))
will give you the count.
If age is being calculated in the query I think that you will have to replace age with that calculation at every point.
Brian
