Page break at the last day of the month

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

Guest

I have a report that I would like to page break whenever the date shown gets
to the last date of the month. The report shows data for each day of the
month for several funds. Currently they are overlapping on the sheets.
 
I have a report that I would like to page break whenever the date shown gets
to the last date of the month. The report shows data for each day of the
month for several funds. Currently they are overlapping on the sheets.
Click to expand...

Not sure how you wish to handle the various years, so adapt the
following.

Group the report by
= Format(DateField],"mm/yyyy")
Sort Ascending

Then set the Group Header ForceNewPage property to Before Section
Add a second sort Ascending (no header) in the Sorting and Grouping
dialog
[DateField]
underneath the above.
 
Back
Top