Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports (2002 (10.2616.2625))

    This little problem is getting to be a pain.

    I have a table with the information I need on a tag. I am using a query to only see the last row of the table (So I only see 1 tag info, the last tags info)

    the query with 1 record in it (it is information to be printed on a small tag 2"x3") I want to be able to print more then 1(so not to waste paper) on a page and I want to be able to say how many to print (as this number changes between each label).
    example:

    1 record I need 4
    2 record I need 12
    3 record I need 3
    4 record I need 18

    how do I print the same report many times from 1 record in a query but the number of times changes with each tag.

    please help

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Reports (2002 (10.2616.2625))

    This article in the Microsoft Knowledge Base tells you how to print multiple copies, and also how to start printing in the middle of a page to use up the balance of a sheet of labels.

    http://support.microsoft.com/default.aspx?...Product=acc2000
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (2002 (10.2616.2625))

    Thanks a lot this looks great...I looked on the microsoft site for 2 hours yesterday and did not find anything...

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (2002 (10.2616.2625))

    Hans recently posted some code that may be of help:

    Re: Multiple labels from each record (Access 97, Win 2000)
    Post: 347508 re: 347497 from MarkU

    HTH John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •