Display records that have same data in some of the fields

[rinos2]

I have a sql query that returns records related to a person. This record has 5-6 fields. The query returns multiple records for this person because 2 fields have different data in the records that are repeated. In the report, I need to display the first record with data in all the fields, but in the second record I need to display just the two values that are different. Also, the second record should be displayed so that it looks as if it belongs to the first one.

Thanks!

 

[dhookom]

There is a Hide Duplicates property of text boxes that might meet your needs. If not, please come back with some sample records and desired display.

Duane
Hook'D on Access
MS Access MVP