report page breaks on data change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2000, I have a application tracking session registrations.
Includes Registrant name, Home dept., session date, session time. I use a
query to select records and then print a session sign in report.

I would like to set up the report so that the query might select records for
a range of dates/times, they would be sorted by date/time. and the query
works this way now.

I want the report to start a new page each time the date/time combination
changes. I have tried inserting a page break following the data in the
detail section, but this simply forces one page break after the first group
of records, then all other records are printed together.

By way of example: query selects 3 records for tuesday 9am, 12 records for
tuesday 11am, and 7 records for Wednesday 4pm. I want separate sign in sheets
for tue 9am, tue 11am, and Wed 4pm session

Thanks for any Suggestions??..
 
JR said:
Using Access 2000, I have a application tracking session registrations.
Includes Registrant name, Home dept., session date, session time. I use a
query to select records and then print a session sign in report.

I would like to set up the report so that the query might select records for
a range of dates/times, they would be sorted by date/time. and the query
works this way now.

I want the report to start a new page each time the date/time combination
changes. I have tried inserting a page break following the data in the
detail section, but this simply forces one page break after the first group
of records, then all other records are printed together.

By way of example: query selects 3 records for tuesday 9am, 12 records for
tuesday 11am, and 7 records for Wednesday 4pm. I want separate sign in sheets
for tue 9am, tue 11am, and Wed 4pm session
Click to expand...



This is typically done by grouping on the date/time field
and setting the group header section's ForceNewPage property
to Before Section.

Use the Sorting and Grouping window (View menu) to specify
the grouping field, which, in this case, will take care of
sorting on the same field. Sorting the data in the query is
a waste of time, because the report's Sorting and Grouping
will override whatever sorting was done in the query.
 
Back
Top