Force Page By Field

[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

 

[Allen Browne]

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.

 

[Andrew]

Mr. Browne, As always you have been a great help. Direct and to the point!
Solution works great!

Respectfully
--
Andrew
H.W. Lochner

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.

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.