Set Visible - Prev Record

[Guest]

I have a report to summarize specs for jobs based on General specs, Floor
specs, Room Specs and Product specs. The report is created from a union query
pulling together all specs from 4 tables then grouping by General, Floor,
Room and Product. Some fields match the group above and I would like to set
the visible value to false if it matches the last value in the same named
field in the group above it. The hoped for outcome is to highlight null
values with conditional formating and print only <> values for quick
reference to the Project Managers and Engineers.

Any help is much appreciated.

 

[Marshall Barton]

I have a report to summarize specs for jobs based on General specs, Floor
specs, Room Specs and Product specs. The report is created from a union query
pulling together all specs from 4 tables then grouping by General, Floor,
Room and Product. Some fields match the group above and I would like to set
the visible value to false if it matches the last value in the same named
field in the group above it. The hoped for outcome is to highlight null
values with conditional formating and print only <> values for quick
reference to the Project Managers and Engineers.

You can use a text box in the group footer section to hold
the group's last detail's value. Set this text box's value
in the group footer's Format event:
Me.txtPrevXXX = Me.txtXXX
where txtXXX is the name of the text box bound to the XXX
field.

Then use the group header section's Format event to
manipulate the txtXXX text box:
Me.txtXXX.Visible = (Me.txtXXX <> Me.txtPrevXXX)