Hiding Duplicates results in Blank Lines in Report

B

Becky

How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?
 
D

Duane Hookom

Do you want to remove duplicate records from a report? Have you tried
setting the controls to Can Shrink: Yes?
 
M

Marshall Barton

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.
 
Top