Grouping Question

[Gremmel]

I have a working report which groups by a status field. Let's say I have Status (AA, BB, CC, DD, EE). It is grouping and summarizing fine. I would like to be able to merge some groups. So I would like to be able to Group on (AA/CC, BB, DD/EE).

What would be the best way to approach this?

Make any sense?

Grem

 

[JHB]

If you report is based on a query, then you could add a "grouping" field to use by the grouping in the report, (if you don't can get it to work on other ways).
Like so, (not tried):

GroupingField:Iif([Status]="AA" or [Status]="CC";"AA/CC"; Iif([Status]="BB";"BB";"DD/EE"))

 

[Gremmel]

Thanks JHB. The IIF was the path I thought I needed to pursue.

I attempted to put something similar in the "Grouping and Sorting" area of the report. Where would that go belong in the query? Or would I put all of the IIF statement in place of the status field in the SQL? Btw, I am working in Access 2013.

TIA,
Grem

 

[Gremmel]

Thanks again. I was able to get it to work within the query design. Thanks again for the lead!

 

[JHB]

You're welcome - luck with your project.