R
Rose
I would like count the number of clients in my table that fall into the
following age groups in my query or report. 62 and over, 51-61, 31-50,
18-30, 13-17, 6-12, 1-5, Under 1. I currently run 8 queries with the count
feature using Age Criteria changing each time and based off of the Birthdates
statement Age(DateDiff(“dâ€,[Birthdate],Now())\365.25))). Any ideas on how
this can be done in one query? --
Rose
following age groups in my query or report. 62 and over, 51-61, 31-50,
18-30, 13-17, 6-12, 1-5, Under 1. I currently run 8 queries with the count
feature using Age Criteria changing each time and based off of the Birthdates
statement Age(DateDiff(“dâ€,[Birthdate],Now())\365.25))). Any ideas on how
this can be done in one query? --
Rose