I am preparing a report using acces

[erich13us]

I am preparing a report using access that calculates each persons age, counts the number of people at each age and groups them by 10s (0-10 10-20 etc.) How can I change that to 2-12, 12-22 etc.?

 

[SoloDroid]

Hello erich13us,
Please provide more information, as there is not enough to advise you on.

Thank you,
Robert Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com

 

[wemeier]

I'm assuming you are grouping them by 10's using the Group Interval in the report Sorting and Grouping properties.

If you are, the only way I can think of is to create another field that is 2 less than each person's age. Group by 10's using this field instead of the person's actual age. Don't display the calculated field, just the actual age field. Nobody will be the wiser.