Force Page By Field

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello,

I'm attempting to print a report that will force a new page once the report
(which has been sorted by [Item_Name] ) encounters a new [Item_Number]. Both
fields are indexed and non duplicate. I have tried all combinations in the
sort and grouping in the report section... to no avail. annnnnnyyyyy
suggestions?

P.S. while I can write an (or use the parameters) expression that asks for
Item_Number, this forces the user to remember each an every Item Number or
whatever parameter is used.... The Item number is in the report header
section.

Thanks
 
Since Item_Name and Item_Number are both unique, I assume the Item_Name will
change whenever the Item_Number changes. You can therefore group by the
name, and force a new page when this changes.

1. In report design view, open the Sorting And Grouping pane.

2. You already have the Item_Name there.
Select this one, and choose Group Header: Yes.
Access responds by adding an Item_Name Group Header to the report.

3. Right-click the new group header, and choose Properties. Set Force New
Page to:
Before Section
This gives you a new page before each new item name.
 
Mr. Browne, As always you have been a great help. Direct and to the point!
Solution works great!

Respectfully
--
Andrew
H.W. Lochner


Allen Browne said:
Since Item_Name and Item_Number are both unique, I assume the Item_Name will
change whenever the Item_Number changes. You can therefore group by the
name, and force a new page when this changes.

1. In report design view, open the Sorting And Grouping pane.

2. You already have the Item_Name there.
Select this one, and choose Group Header: Yes.
Access responds by adding an Item_Name Group Header to the report.

3. Right-click the new group header, and choose Properties. Set Force New
Page to:
Before Section
This gives you a new page before each new item name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Andrew said:
I'm attempting to print a report that will force a new page once the
report
(which has been sorted by [Item_Name] ) encounters a new [Item_Number].
Both fields are indexed and non duplicate. I have tried all combinations
in
the sort and grouping in the report section... to no avail. annnnnnyyyyy
suggestions?

P.S. while I can write an (or use the parameters) expression that asks for
Item_Number, this forces the user to remember each an every Item
Number or whatever parameter is used.... The Item number is in the
report header section.
Click to expand...
Click to expand...
 
Back
Top