Filtering Out Duplicates in Labels

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top