Access Counting records based on multiple age bracket and output to tabulated report

Joined
May 12, 2017
Messages
1
Reaction score
0
I want to be able to count the number of records for specific criteria - i.e., how many records are in a particular age bracket. The age brackets are as follows: .1-2 yrs old, 2.1-5 yrs old, 5.1 to 9 yrs old, 9.1 to 14 yrs old, 14.1 to 19 yrs old, 19.1 to 59 yrs old and 59.1 to 60 yrs old and above. All age bracket will be on a separate column on the tabulated report.

I would like to be able to display this count number in a query or in a summary report of the age brackets. I'm quite new to access. Thanks.
 
Back
Top