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

Sabtu, 26 November 2011

[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
>