Report Grouping: Multiple values under one common grouping

[TonyD1016]

I'm currently setting up an access report with multiple grouping levels.
One of these levels is by "County" and there are eleven unique values that I am dealing with: Berks, Bucks, Carbon, Chester, Delaware, Lehigh, Monroe, Montgomery, Northampton, Philadelphia, and Pike.

I would like records for three of these counties--Carbon, Monroe, and Pike-- to be grouped together under the under the heading of "Carbon/Monroe/Pike" and the remaining values under their own names.

I know that programmatic grouping is possible in Access, but I cannot wrap my head around the best way to accomplish this.

Anyone have any advice?

 

[TonyD1016]

I've come up with a workable solution by changing the underlying report query.
I changed the original [County] Field entry to the expression:

County: IIf([County]="Carbon","Carbon/Monroe/Pike",IIf([County]="Monroe","Carbon/Monroe/Pike",IIf([County]="Pike","Carbon/Monroe/Pike",[County])))

This created the county grouping I needed in the underlying query and I simply added it as a sort level in the group report.

But if there are any better solutions the community has I'd love to hear them.

 

[Micron]

Another approach might be to have a grouping level that the ones you're trying to group belong to. So those 3 counties belong to group e.g. "South".