Report-Duplicates

[Renetta]

Hi,

I have created a report formated as a letter. I'm using the detail
name/address info in the letter based off of a query that has duplicates.
Now for the query it is ok as they are trully not duplicates based on
additional detail housed in the table (ssn/account #'s), however I want to
supress the duplicates in my report/letter (names, Address) as I only need
one letter per Name/Address. Any suggestions? Not sure if I should produce
another query that runs off of the 1st query or if there is a way to supress
via the report. FYI, I am pretty new to the stuff so some guidence would be
helpful. Thanks.

 

[Duane Hookom]

I think you might need use a subreport to display the detail information and
base your report on summary information.

 

[Renetta]

Is there a way to supress that detail via the query lets say if I queried of
the query. If so, how would I do that?

 

[Duane Hookom]

You get make a totals query but then you remove the information that is not
repeated.