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

    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.

    JP

    Any help would be appreciated.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Something like

    Code:
    For vLabel = 1 To Quantity
       'PrintALabel
    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
  •