ACCESS FEED: RE: [MS_AccessPros] Re: Printing Multiple labels- different number of labels for each record

Sabtu, 26 November 2011

RE: [MS_AccessPros] Re: Printing Multiple labels- different number of labels for each record

Kumar-

That should work. What values are in DeliveredQty?

Let's say you have 100 rows in T_labelQty (values 1-100). By including
T_labelQty with no join, you should get 100 repetitions of the rows in
T_POLabels with no criteria. Add the criteria, and it should produce
DeliveredQty number of rows for each row in T_POLabels. Do you get the expected
number of rows without the criteria?

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: Sunday, November 27, 2011 3:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Printing Multiple labels- different number of
labels for each record

Thanks, John.
I understood your methodology and tried it but it is not working. I am
explaining what I did, please let me know where I am doing wrong.

I created a simple table T_labelQty with numbers 1,2,3 etc. as rows. I then
created a query including the table T_labelQty and my original table T_POLabels
without join and the set the criteria for LabelQty as <=[DeliveredQty]. However,
I am not getting the number of rows in the query equal to delivered quantities.
Why?

Regards,
Kumar

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>

------------------------------------

Yahoo! Groups Links