Count in report

[Eoluke]

Hello, I have a query that has a calculated field for "Current Age". I would like to create a report that simply will count the number of people within certain age brackets. Ex: 21-30, 31-40, 41-50 etc. It seems like there should be a simple solution to this but as a total noobe, it escapes me. Any ideas out there? Thank you so much in advance.

[CJ_London]

have a look at the partition function for sql

https://support.office.com/en-us/art...7-c94278274dc5

[June7]

Calculate an age group field in query or in report design. Use that constructed field to group and count records.

Switch([Current Age]<=30,"21-30", [Current Age]<=40, "31-40", [Current Age]<=50, "41-50", True,"Over 50")

EDIT: or use Ajax's suggestion for Partition function.

[Eoluke]

Both interesting however I have no idea where to start or put these. I guess it isn't as easy as i thought.

[June7]

You do this in the Field row of a query. Basic Access functionality. You should probably complete some tutorials. Start with http://www.rogersaccesslibrary.com/

[Eoluke]

Ok, I made a calculated field using "switch". I also made a simple report and grouped by this field. It works wonderfully. The report has a total count in the report footer. Is there a way to separate that count by the age groups?

[June7]

Do a calc in the GROUP header or footer section.

[Eoluke]

Using "Count" in a text box and can't get the syntax right but will keep trying. Thanks for all your help.

[June7]

Syntax is same as the calc in report footer:

=Count(*)