Results 1 to 2 of 2
Thread: Report Query Joins (Access 2000)
2001-09-14, 17:24 #1
- Join Date
- Aug 2001
- New York, NY
- 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?
2001-09-14, 18:49 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- 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