John,
Thanks it is working. The records were not sorted in the report properly and I was not able to check if it is printing the right number of labels. Thanks once again.
Regards,
Kumar
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar