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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top