My DB is used for an online store, it is a flat file structure that basically uses 2 tables; one for the customer information, and another with their purchase info.
The customer info is in a flat file structure while the customer data is a single column. Basically the flat file refrences the customer's order details and lists them vertically.
Using sub-reports I was able to get the user data and their corresponding orders to show up in the specified printing area for mailing labels. However, the problem now arises that a new label is being made for every different item they ordered. Example, customer A orders 1 item, only one label is made, customer b orders 2 items, a label is made with both items, and another label is also made with both items on it...this goes on for 3, 4, 5...any number of items. How can I get the reports to only print 1 copy of each label?
Thanks!
The customer info is in a flat file structure while the customer data is a single column. Basically the flat file refrences the customer's order details and lists them vertically.
Using sub-reports I was able to get the user data and their corresponding orders to show up in the specified printing area for mailing labels. However, the problem now arises that a new label is being made for every different item they ordered. Example, customer A orders 1 item, only one label is made, customer b orders 2 items, a label is made with both items, and another label is also made with both items on it...this goes on for 3, 4, 5...any number of items. How can I get the reports to only print 1 copy of each label?
Thanks!
