Hiding Duplicates results in Blank Lines in Report

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?
 
Do you want to remove duplicate records from a report? Have you tried
setting the controls to Can Shrink: Yes?
 
Becky said:
How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?
Click to expand...

Hide duplicates is not intended for that kind of thing. You
should probably either remove those records from the report
record source query, possibly using the Distinct keyword.

If you need the records but don't want to see them, you
could create a group on the field(s?) and place the controls
in the group header.
 
Back
Top