Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Printing with query and quantity.

    Hello folks,

    I'm not that great in access and I was told by a friend of mine to come here for some help. So let me explain my issue.

    I am working on a production database. I am trying to print labels of a product. If a customer orders 5, then I need to create 5 labels.

    So I have a table "Orders" that holds each order. In the table there is a column for quantity "qty". So I do my report from a query which gets me the pertinant information to go on the label. Now if I have an order with a quantity of 5, how do I automatically get 5 labels to print instead of having to print the order 5 times? If this doesn't make sense, please let me know and I will try to explain in more detail.

    I tried searching for the answer and I don't think I am doing the search properly.

    Thank you very much for your help.


    Any help would be appreciated.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Something like

    For vLabel = 1 To Quantity
    Next vLabel
    Might point you in the tight direction.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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