Print Multiple Labels

[campbellhatchard]

To anyone that can help, my eternal gratitude!!

I am wishing to print labels for freight going to clients. I have a Table which has client name and address details and a despatch table which contains the date, client no and no of items. I have created a query which combines the information into a label containing the information required. My problem is twofold;

1. I want to be able to specify the number of labels to print automatically drawing the number from the "No of Items" in the despatch table.

2. I want the labels to print out showing sequential numbers, for example, if the No. of items is 4, I want to have it print 4 labels, the first showing "1 of 4", the second "2 of 4" and so on.

Thankyou to anyone who can be of assistance.

 

[shannonp]

I would tackle this problem by first creating a table (CALLED 'NUMBERS') with one KEY variable (AGAIN CALL IT 'NUMBERS'. In it simply enter in values 1 to 10 (go to 100 or higher if necessary).

Then I would use the following SQL to handle this:

====================
SELECT Customer.CustID, Customer.Customers, Customer.Address, [Number] & " of " & [How many?] AS [Label #]
FROM Customer, Numbers
WHERE (((Customer.CustID)=[Enter Customer ID]) AND ((Numbers.Number) Between 1 And [How many?]));
====================

Your code will of course be different but should be able to be moulded to suit your needs. I have a small DB with one query in it should you need it. (although you most likely have the answer already)