I'm trying to extend an inventory manager db I built for class, but I'm running into some problems with my reports.
I have two linked tables, one with top level information, i.e. Order#, Customer Info, etc... and one that's linked to Order # and has details, i.e. Vid1, Vid2, etc...
What I want to do is create this report such that it showed the Order# and associated detail fields on each page. But I have no idea how to insert the page break after the LAST detail field for that Order# so it does this:
Is it possible to get Access to insert the page break after the last detail record? Or am I barking up the wrong tree?
Right now to generate a report that shows only one Order# and it's details on a page, I'm basing the report on a query filtered by Order#.