Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access/VBA - Force New Page, but new groups on odd pages

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have a report, that works like a charm, with 2 groups.
The outer group, is Building Name, the inner group is date..
so I'm having a building, with everything in it sorted by date of entry... lah lah.
Now, i love that it force's a new page for me on the dates.. i'm within a building, and I just want to break on dates.

Here is my dilemna.. for an index, i'd really like it, if when I was 'forcing a new page' for a new BUILDING(outer group), it would only do that force, if the current page was even.. if i'm already on an odd page, I don't want to force and end up printing on an even page.

Hopefully this makes sense. If it makes even partial sense, help me out, and maybe you can save me from going crazy.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top