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:

page1:
Order1
Movie1, Movie2
page2:
Order2
Movie1

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#.

You need a group footer. I am assuming you are using the Sorting and Grouping options to group by your orders. Set it to show a group footer. In the group footer's properties, set the "Force New Page" property to "After Section"

Thanks Brian! I didn't know you could do that with a group footer!

Glad to help.