By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,702 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,702 IT Pros & Developers. It's quick & easy.

Print Multiple reports based on field values

P: 1

I have a table where one field is "PO" and this field has multiple values (txt format).
One "PO" value can be used for multiple "EndItem".

- I want to print separate reports with the same header and footer (already created)
- Each page should be specific to one value of "PO" field
- That value should be in the header for that page, while the display part of the field contains the associated "EndItem" and other values specific to that "PO" value.

I don't want to create Multiple Reports, I just want multiple pages based on the field "PO" value.

Thx for the help
Mar 17 '14 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,240
Hi. Welcome to Bytes.

What you want is to make one report and group by PO. Set Group Header and Footer to True. Leave the page header empty. Put what you want in the Group Header. and in the Group Footer put a page break (you can find that in the tool bar).

The result will be all the items for one PO value followed by a page break.

Mar 17 '14 #2

Expert 100+
P: 1,240
See the examples in the sample database that came with your copy of MS Access for more help.

Mar 17 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.