exclude data on reports?

[bassispunk]

how can i exclude entire records from a report? for example, for sending out mailings(ie creating a mailing label report) in which the recipient may have been listed in the report 2 times, how do i remove the 2nd, 3rd, nth instance of their record? I have tried the "exclude duplicates" in the field properties, but that only excludes the field and not the entire record. any thoughts? thanks.

 

[Rich]

Use a query as the record source and set unique records to yes.