Separating groups / different pages

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I am creating a report to summarize a group of engineer's
projects. I want to separate each person onto different
pages. I was thinking of creating a query for each person
but is there a better way in the report wizard to ensure
page breaks from just one query that contains all of the
engineers?

Thanks
 
Creating a new report for each engineer is multiplying your work
exponentially! Instead, add a group header in your report as follows:

View:Grouping and Sorting - add the engineers field and set the Group Header
to Yes... then set the new section's Force New Page to Before Section

HTH.

Tom.
 
Mac said:
I am creating a report to summarize a group of engineer's
projects. I want to separate each person onto different
pages. I was thinking of creating a query for each person
but is there a better way in the report wizard to ensure
page breaks from just one query that contains all of the
engineers?
Click to expand...

Generally you would use a group header section for each
person (use Sorting and Grouping to create group with header
and/or footer).

Each section in a report has a ForceNewPage property. You
should be able to get what you want by using one of the
available options (probably Before Section).
 
Sunny said:
How do I print # of records in each group in group footer?
Click to expand...

Generally, by using a text box in the footer with the
expression =Count(*)

Did you get each engineer's data on a new page?
--
Marsh
MVP [MS Access]


 
Back
Top