dont show duplicates

[Guest]

i have several items on a report and only want them to show once

for example

joe smith
joe smith
joe smith

i only want joe smith to show once is there something that i can do to
not show the duplicates and get rid of the space i saw there is a property
hide duplicates but it doesnt get rid of the space on the report ?

 

[Rick B]

Either modify your query to exclude them, or set up your report's sorting
and grouping options to group by your name field. Then put your name field
in the group header, not in the detail section.

 

[Guest]

You can also set the Hide Duplicates setting to YEs. In the report design
view, click the field you want to have supressed, open the field properties,
click on the All tab and set the Hide Duplicates value to Yes.

 

[Guest]

Keep in mind any values in that row that you try to supress will still appear
as values when summed or counted in the detail footer though...I currently
don't know how to get them to fully 'dissapear' if a record is a
duplicate...I only know how to hide them.