Multiple Labels

[Exodus]

I want to be able to print multiple labels based aon a quatity in a field.
one label would say 1acw2467 the second 2acw2467
Can this be done?

 

[Exodus]

Well this is what I did. I created two querries one for every record then one for eveyone I need two for then combined them in a union query.
This came from another site.

 

[oldaf294]

exodus,


This solution works very well for me. Add a table to your database that only has one number field. Populate this table "Number" to contain sequential numbers 1 to whatever the maximum number of labels you would ever print.
Add this table to the query that is the record source for your report. Do not join it.
Add the field that contains the numbers to the query grid and set the criteria for this field to:
Between 1 And [NameofyourQuantityfield]

If your "quantity" field has 3, then there will be three entries in the query
if the "quantity" field has 6, then there will be six entries in the query.
I hope this is what you are wanting to accomplish.
jim