duplicate a copies of a report based on a field condition = Yes

G

Guest

I'm generating labels from a customer order database. The order table allows
customers to "Split" an order of food, requiring my DB to generate 2 lables
for the customer.

I'd like to autogenerate the labels (in order based on customer name) in a
nightly batch process, but I can't figure out how to print 2 copies based on
the field cSplit = Yes.

Any help would be appreciated.
 
G

Guest

Use code to print two copies, the simple way

If cSplit = Yes then
docmd.Openreport "ReportName"
End if
docmd.Openreport "ReportName"
 

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

Similar Threads

repeat a copy of a report based on a parameter 1
Printing multiple copies based on the group in the report 2
Access MSACCESS - Sorting report based on field calculated in the report 0
Formatting based on total in Footer 1
Print mutiple copies of report based on field 1
Duplicate copies of a report 1
Duplicate Records in Report View 5
duplicate records for labels 2

Top