I'm creating an aging reporting in Access 2010. Using the 'Grouping' function, I've grouped the results in 90 day intervals (0-89 days, 90-179 days, etc.) However, since my data set includes some older records my last results 'bucket' is 4770-4859 days. I need to group all the older records together in a >720 days "bucket".
The current coding in the control source is as follows; =Int(([Age])/90)*90 & " - " & Int((([Age])/90)+1)*90-1
How can I revise the coding to get the result that I need?
Thanks!