I would create a small table [tblCopies] with a two fields [CopyNumber] (numeric) and [CopyTitle] (text) and add two records
1 Office
2 Customer
Add this table to the report's record source and don't join it to any other table. Add the CopyTitle to the query grid. Then your report will print two copies of each record.
If you want, you can bind the CopyTitle field to a text box.
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: maxccess@gmail.com
> Date: Wed, 3 Jul 2013 18:02:12 +0500
> Subject: [MS_AccessPros] Print a report twice
>
> Dear All,
>
> I have a A4 size access report for sales invoices how do I print this
> invoice twice i.e one office copy one Customer copy in one go
>
> --
> Regards,
> Abdul Shakeel
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar