RichMorrison
Registered User.
- Local time
- Today, 14:34
- Joined
- Apr 24, 2002
- Messages
- 588
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
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