Removing dupe detail records

[bulrush]

A2003 on Win XP.

Tables called "Master" and "Detail" in a one to many relationship.

I have a report that uses a Master table linked to one or more records on a Detail table. The report is based on a Query. The report currently prints multiple Master records if there are multiple Detail records. For example, if there are 3 detail records, the report prints 3 Master records. I want the report to print one Master record regardless of how many Detail records there are. The point of the report is to make sure a Detail record exists, before printing the associated Master record so the Detail table MUST be part of the query.

How do I go about this? Do I do something at the query level? At the report level?

There must be a way to collapse multiple detail records down to one detail record. It doesn't matter what the value of the field on the Detail table is, as long as a Detail record exists, print the associated Master record on the report.

Thanks.

 

[Magster]

Are you using grouping on your reports? If you're not, then try that.

If you have only a detail line on the report using both your parent and child data, on each parent field, set hide duplicates on each parent field.

 

[bulrush]

Yes I am. One of the fields on the Master table is called "Name". When I put the field "Name" in a groupby based on "Name", I still got dupe records.

Just to reiterate, I don't want to show any records on the Detail table, but I do have to check them.

In the report's query, I also unchecked the Job field on the Detail table (that's the field that must exist for a related Master record).

EDIT: I think making a Group based on Name worked.