Filtering Out Duplicates in Labels

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am creating letters reminding customers to reorder our
products using an MS Access Report. The letter is based
on a query. The query will often have the same customer
name and address listed several times but with different
product names. When I created labels using reports for
these letters am getting a lot of duplicate names which I
don't want. I don't want to change my query using
distinct or anything else because it is perfect for the
letters. Is there a property I can change for my label
report which will filter out duplicates?

Thanks,

Chuck
 
Change the RecordSource of your report to:
SELECT DISTINCT ... FROM MyQuery

Alternatively, you could create a Group Header section on the ClientID (or
whatever is duplicated). Move the entire label into this section, and set
the Detail section to zero-height. It's much less efficient than the query
approach, but should work.
 
Back
Top