Display records that have same data in some fields

[rinos2]

Please see the data to be displayed below:

Name Item# SSN Type Date Status Company Notes
xyz 1 5462 a 10/01 Approved uvw test1
xyz 1 5462 b 10/01 Approved abc test2

The above records are for the same person (xyz). I need to display the first record with all the data as shown above. However, for the second record, I just need to display the data in the Type, Company and Notes fields because the data in the other fields is the same as in the first record.

I tried using the HideDuplicates property of the textbox but it hides the duplicate data in all the remaining records. But this will not work in my case because I have records for different persons. So, I need to show the data if it is a different person.

Thanks!

 

[Remou]

Where do you wish to display the data? A form? a report? How do you decide which is the first record?

 

[dhookom]

I'm not sure why you created a new thread rather than responding in the thread you created yesterday.

You could try create a group header on the duplicated fields. Then put only the unique fields in the detail section. Add a text box to the detail section:
[tt][blue]
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No
[/blue][/tt]
Then add code to the On Format event of the detail section:

   Cancel = (Me.txtCount = 1)

Duane
Hook'D on Access
MS Access MVP