Using 1 report to print an Invoice and a Delivery Note

[Chris]

I need to print the same report as an Invoice and as a Delivery Note. The
only difference between the two are a Text Label that has to change, stating
if the document is an Invoice or a Delivery Note. I need to do this with
Access 2000 VB. Does anybody have an idea how to do this? I also need to
know how to set the number of copies to be printed with VB.


Thx

Chris

 

[Duane Hookom]

I would create a table "tblCopies" with two fields [CopyNum] and
[CopyTitle]. Add the records:
1 Invoice
2 Delivery Note

Then add this table to the record source of your report and don't join it to
any other table. Add the two fields to your query grid. Set the first level
of Sorting and Grouping to [CopyNum] and create a header and footer. These
would replace previous Report Header and Footer sections. You can then add
these fields to your report and get one copy of each.