Duplicate Labels


D

D Collins

Hello,

I have a query that locates clients based on different
criteria. One client could show up multiple times. I
have tried to set query properties such as unique values,
or unique records, but neither is working to eliminate a
duplicate address label (addressed to the same person,
same company, etc.)

I believed I tried to use the field property: hide
duplicates, but it would leave a blank label.

Any ideas on how to get only one label of its kind to
show up?

Thanks, D.
 
Ad

Advertisements

A

AlCamp

D,
If I understand correctly...
Have you tried a "Totals" query, where duplicate adddress labels would be
forced to "GroupBy" to just one record?
I haven't tried this, but it should work.
hth
Al Camp
 
D

D Collins

Thanks, I'll give it a try.

-----Original Message-----
D,
If I understand correctly...
Have you tried a "Totals" query, where duplicate adddress labels would be
forced to "GroupBy" to just one record?
I haven't tried this, but it should work.
hth
Al Camp




.
 
D

D Collins

I tried your suggestion, but the query that drives the
labels has 4 criteria fields. If I group by, then there
is no distint grouping, as the company could appear in
more than one category, etc.

How can I have it still group, but ignore the criteria
field grouping?

Thanks.
 
Ad

Advertisements

M

MustBNuts via AccessMonster.com

What I've done in the past to remove the duplicates is to view the query in SQL View and after the word SELECT add the word DISTINCT, this eliminates my dups.

Hope this helps,

MBN
 

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