Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Labels printout duplicates based on records in subform

    :?: 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

  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA

    Please post the SQL for the query underlying the reports.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Counting records based on specified criteria
    By GrnISSO in forum Queries
    Replies: 2
    Last Post: 10-04-2007, 03:07 PM
  2. Open form based on Subform criteria
    By Suzan in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 02:28 PM
  3. cannot print labels
    By Diane in forum Database Design
    Replies: 4
    Last Post: 12-29-2005, 08:19 AM
  4. Replies: 1
    Last Post: 12-10-2005, 04:52 PM
  5. Subform in a Subform and relationships
    By St3ph3n in forum Database Design
    Replies: 3
    Last Post: 12-06-2005, 06:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums