Reset page number on invoice forms

D

Dennis

All,

I am running Access via Office XP Pro on Windows 7.


Background:

I am working on an invoice "form" report. (By form I mean the actual form
that I will hand the customer versus an data entry form.) I have it pretty
much working thanks to different members on this form, but I have another
question.

For this report Work Order number is also used as the invoice number.

The report is comprised of the following parts:

Main report: row source is qrytblWorkOrder table (Invoice rcd)
WorkOrder Header - Grouped by Work Order / Inv No #
Detail
Page Footer

Sub-report – row source is qrytblWorkOrderDet table (transactions)
WorkOrder Header - Heading for detail line via Repeat Section = Yes
Grouped by Work Order / Inv No #
Detail
WorkOrder Footer - Invoice totals

Here are my questions.

1. After each invoice (group) on the main report prints, I want to reset
the values Page and Pages. I want the first page of each invoice to be page
1, the second page 2, etc. for each invoice. And I want to be able to print
Page x of y in the page footing of the invoice where “y†is the number of
pages for the specific invoice.

2. I want to be able to have my details print across the pages. I was
testing my report and I move my sub-report down a couple of lines. Before I
did that, all of my details printed on the first page. After I moved down
the sub-report in design mode, all of the details printed on the second page
and none printed on the first page. The first page was 3/4 empty.

I have set the Keep Together property of the Sub-report, WorkOrder Header
and Detail section of the sub-report to No. But that did not change anything.

Any suggestions?

Thanks,

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top