:?: I create a labels from a report that has a subreport. It is fueled by a query that consists of 2 tables with a one to many relationship. If there is more than one record in the subreport, all the records print correctly but print as many times as there are records. This is for a tenant and occupant label with several occupants to one tenant. If there is one tenant and 3 occupants, the label will print correctly, listing the tenant and all three occupants on one label but it will print out (one tenant, 3 occupants) 3 times, one time for each occupant record. The grouping is as follows: No Group Header or Footer, Grouped on Each Value, Group Interval is 1, and Keep together is Whole Group. Sorting is on the apartment number. What can I due to stop this.
TIA for any ideas.
Sue Van