Multiple copies a field on a report

[Sail101]

I have a report that I need to generate. The report will be used to help control and track production times for products that we manufacture. The report will show the different times required for the individual production steps as well as the order number and date. I have all of this on the report and in the format required but I need to have multiple copies of this information on the report and the number of copies is determined by the the quanity of product ordered by the customer. I am not able to fugure out how to get a loop to work so that it will print the record on the report X times.

Thanks Sail101

 

[PaulBricker]

The adjustment will need to be made in your query underlying the report. Look at this FAQ by CosmoKramer

faq703-3276

Cosmo wrote it for labels, but it should do what you want as well. Just follow the steps and your query will produce the appropriate number of records for each quantity in your records. Give it a try and post back with specific problems.

Paul

 

[Sail101]

Thanks, it worked like a charm

Sail101