Obtaining counts of age groups

  • Thread starter Thread starter Nick Bygrave
  • Start date Start date
N

Nick Bygrave

I am a beginner at Access and would be grateful for some
help.
I have a simple database table of people records each
containing Date of Birth.
I want to produce a summary report containing the number
of people in each 10 percentile as of todays date. I can
see how you calculate the age of any one person with the
Datediff and Now functions but can't see how to produce
counts of eg the number of people aged between 50 and
60,60 and 70, 70 and 80 and so forth on a Report.

Any advice would be appreciated.
 
DateDiff() and Now() might not give you truly accurate ages. There are
functions/expressions at http://www.mvps.org/access/datetime/date0001.htm
that provide accurate ages.

Do you want to only show the totals in your report or do you also want to
show details. If you only want totals, then create a totals query that
groups by your
[AgeExpression]\10
 
Back
Top