Can not print " Grand total " to pre-printed invoice

  • Thread starter Thread starter Shipshape Sea Store Co., Ltd.
  • Start date Start date
S

Shipshape Sea Store Co., Ltd.

I want to use Access 2002 to issue invoice.

Now we use excell and print only data to pre-printed invoice.
(preprinted invoice = it already print logo and table on paper but will blank a data)

My report has 3 page and i want "total, vat, grand total" to print at end of page3 only.
First, I use report footer, it will print after end of detail not end of page3
Second, I use page footer, it will print end of page 1,2,3 not end of page3 only
Third, I use page footer and "Not with Rpt Hdr", it will print end of page 2,3 not end of page3 only

If anyone can provide any assitance, it would be greatly appreciated.
 
Use 3 unbound text boxes in the Page Footer section.

Use the Format event of the Report Footer section to assign values to the 3
unbound text boxes, and set the Visible property of the Page Footer to Yes.

Use the Format event of the Report Header section to set the Visible
property of the Page Footer to No. That saves it printing wrongly if the
user previews and then prints.

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

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

"Shipshape Sea Store Co., Ltd." <[email protected]>
wrote in message I want to use Access 2002 to issue invoice.

Now we use excell and print only data to pre-printed invoice.
(preprinted invoice = it already print logo and table on paper but will
blank a data)

My report has 3 page and i want "total, vat, grand total" to print at end of
page3 only.
First, I use report footer, it will print after end of detail not end of
page3
Second, I use page footer, it will print end of page 1,2,3 not end of page3
only
Third, I use page footer and "Not with Rpt Hdr", it will print end of page
2,3 not end of page3 only

If anyone can provide any assitance, it would be greatly appreciated.
 
Back
Top