Counts in Reports (1 Viewer)

[Amy]

I have an Age field that has 4 possibilities (21-30, 31-40, 41-50, 50+). In the report, I want to list 21-30 = count of members 21-30, 31-40 = count of members 31-40, etc. How do I accomplish this (please)?

 

[Jack Cowley]

Put an unbound text box in the Report Footer or where ever you like and set its Control source to:
=DCount("[Age]","YourTable","[Age] = '21-30'")

Do this for the other 4 groups of dates and you should be good to go....

 

[Amy]

Thank you, thank you, Jack. It works perfectly!