I am producing a product check sheet for a date range for a number of different customers. Now the product check sheet may only be 1 page for 1 customer but >1 for another.
2 copies of each check sheet go on each customer's pallet that we send out.
So I need to automate the printouts so that the no of copies of the pages of the report specific to a customer = No of pallets (PalletQty) which varies depending on the customer (calculated field in the reports query) x 2. I presume it will be some sort of loop situation using the printout command and the field called PalletQty but am not sure where to start.
Any help would be greatly appreciated.
Regards
Antony
2 copies of each check sheet go on each customer's pallet that we send out.
So I need to automate the printouts so that the no of copies of the pages of the report specific to a customer = No of pallets (PalletQty) which varies depending on the customer (calculated field in the reports query) x 2. I presume it will be some sort of loop situation using the printout command and the field called PalletQty but am not sure where to start.
Any help would be greatly appreciated.
Regards
Antony
