Custom Groups

[Lynn]

Is it possible to create custom groups in an Access 2003 report? For
example, I have a report that is grouped by Category. I would like to
specify that Cat 1 & 2 should be lumped together as one group & Cat 3 is a
group of its own. How can I achieve this?

 

[KARL DEWEY]

In your query that feeds the report use a calculated field with IIF statement

 

[Lynn]

Thanks Karl. This worked!

In your query that feeds the report use a calculated field with IIF statement
--
SortCat: IIF([Category] = 1 Or [Category] = 2, 1, 2)
--
KARL DEWEY
Build a little - Test a little

Is it possible to create custom groups in an Access 2003 report? For
example, I have a report that is grouped by Category. I would like to
specify that Cat 1 & 2 should be lumped together as one group & Cat 3 is a
group of its own. How can I achieve this?