I have a need to print serialized copies of the same label defined by a single record. The record keeps a record of the serialization history so the user can respond to a UI asking how many labels are desired and the reports OnDetail can easily attend to the serialization. My question is how to loop on a single record to satisfy the RecordSource of the report. Maybe my question is how to create a query that returns an already serialized set? I can always create a temporary table but had the idea my situation is not the first of its kind?
Any thoughts?
Thanks,
Bill
Edit: E.g., LabelText-1; LabelText-2; LabelText-3; LabelText-4;...............LabelText-n