Print Report by selected field and force new page

  • 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
 
Group by Item_Number, and select the Force New Page option for the Group
Header. If memory serves, you don't actualy have to display a Group Header
for that to work...

Larry Linson
Microsoft Office Access MVP

Andrew said:
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
--
Andrew
H.W. Lochner

__________ Information from ESET Smart Security, version of virus
signature database 4034 (20090424) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4034 (20090424) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top