How print multiple labels based on a query

[SteveL]

I've built a label in Access 2003 which is bound to a query which may end up with multiple records. For each record in the query I have a calculated field, "LabelQty", to tell me how many labels to print. But I can't figure out how to make the application actually print that many labels. For example, one record may call for 20 labels and the next record may call for 65 labels depending of the field in the query. The printing of the label(s) is the result of an OnClick event on a form which triggers the query/report.

How can I make this happen?

--Steve

 

[KeithIT]

Well you could create a report with a snaked column feature and have the report read the records from the query, triggered by the On Click event of the form.