Group but do not Sort (1 Viewer)

Greetings All,

The record source for a report is a query. The query selects Projects and, for each Project, all the Activities. The Projects are sorted by importance and by date. Within a Project, the Activities are also sorted by importance and by date. The query works just fine.

In the report, I want to force a new page when the Project name changes. A Group Header on project name will accomplish this. But that resorts the report based on project name.

I suppose I could generate a new field in the query that represents some kind of sort sequence.

Does anyone know another clever way to do this ?

Thanks,
Rich Morrison

You can force a sort by importance and then by date within that importance by going into sorting/grouping and select your importance first and then add date as the next one (both with headers/footers set to NO) and then put in your project name and select header - YES.

Thanks Bob

Yup, that'll do it.

Thanks,
RichM