New Page for each Group

[WSF]

Access97
I have a report based on a table that lists:

Part Number
Location

There are several Locations and each location can list a number of Part
Numbers - some Part Numbers appear in more than one location.

I am trying (without success) to have a report print so as to list first by
Location, then by Part Number where each Location should start on a new
page, despite some locations running to several pages. But I am having some
locations, with few Part Numbers listed, sharing the same page. I want them
to have their own page(s). What am I doing wrong?

WSF

 

[John Spencer (MVP)]

First ask this in the Reports newsgroup instead of in forms.

In your report, set grouping by the Location field and add a group footer for
the group, and set the group footer to New Page after section.

Details:
Open report in design view
Select View: Sorting and Grouping from menu
Enter Location under Field/expression
Change Group Footer to Yes
Close the window

Click on the group footer
Click on the properties sheet
Click on the format tab
Change Force New Page to After Section
Optional: Set Height to 0 to not show the Group footer section.

 

[WSF]

Thank you John for the answer to my problem.
I have to concede a tad of impatience in posting to two groups.
I have watched this group for some years now and have really benefited from
the very prompt responses, often while I am working on a project. I've
contributed on occasion too but am no guru. I have rarely used other groups
and double posted this time because I reckoned on a faster response from
formscoding. (I was right!) I'm not sure about the business of
cross-posting vs. multi-posting so have conservatively stuck to this group,
so apologies are due this time.
Thanks again

Bill Fraser