Limiting Interval Grouping in a Report

[jokeboy1]

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!

[June7]

Maybe:

=IIf([Age]>720, ">720", Int(([Age])/90)*90 & " - " & Int((([Age])/90)+1)*90-1)

[jokeboy1]

Sadly this still doesn't work. The code doesn't combine all the records. It just makes the heading ">720" and all the groupings after 720.

Any other ideas?

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.