Kumar-
You can find some code examples on the Microsoft website that involve preventing
the report from advancing to a new record "n" times. But my preferred method is
to create a simple table with one Integer field. Create rows in the table with
each row containing a different number from 1 to the max number of labels you
want to produce. For your report record source, include that table in the query
with no joins to any table. Add the number field to the query grid and add
criteria like:
<=[Quantity]
That will generate multiple rows for each detail item up to the quantity
ordered, which will then print "n" labels per product.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Saturday, November 26, 2011 6:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Printing Multiple labels- different number of labels
for each record
Dear group,
I have developed MS Access2000 database for Goods receipts. As the order
quantities may be different for different line items (records), I want to print
multiple labels for each record based on the order quantities. In my T_POlabels
(on which the label report is based), I have a field indicating the number of
labels required for each record.
How do I get the desired multiple labels for each record when I print the
report. Please advise.
Kind Regards,
Kumar
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar