I have a report that gets sorted by date. is it possible to force a page break after each month? the date is formatted as mm/dd/yyyy
I have a report that gets sorted by date. is it possible to force a page break after each month? the date is formatted as mm/dd/yyyy
Might need to consider the year as well as month. Create a group section with expression: Format([yourdatefield],"yyyymm"). Set the ForceNewPage property of that section.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
thank you, that worked perfectly.