Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Location
    New York, NY
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Query Joins (Access 2000)

    I have a report whose data source is a query. The query does a one-to-many join between the master table and the detail table. The problem is that, whenever a query joins the master and the detail, it duplicates the information contained in the master fields, thus attaching the same master information to each of the detail records it retrieves.

    I need to know how to indicate in the report that I only want ONE occurrence of each master record, and that I want all the detail records belonging to that master record to show up in a SUBGROUP.

    Does anyone have any ideas?

    Thanks,
    Steve Weber

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Query Joins (Access 2000)

    One way is to use the Sorting and Grouping feature in the report. You can create a header for the group on the field from the master table and put the information from the master fields in that header. Then put the fields from the detail table in the Detail section.

    Another alternative is to use the HideDuplicates property of the controls in the Detail section. For the fields that get repeated from the Master table, you can set the HideDuplicates to Yes, and it will print that information only for the first record.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •