Creating a custom group on a report

[Karen]

Hello -

I have a report that has three fields "#of Years", "People in school",
"People applied"

The number of years range from 0 (less than 1 year) to 35. I want to group
the records so # of years = 0 thru 6 show as is, and 7+ all other years are
added together under one group and summed together for the "People in School"
and "People applied"

Do you know how I can do this? Should I do this in the report?
Thanks

 

[steveh]

I would use a query, but I suppose you could get the same results in a
report.

Group by [#of Years] and Sum [People in school] and [People applied].
For the [#of Years], you would have something like this:

NumYears: IIf([#of Years] >= 7, "7+", [#of Years])


Steve