Duplicate Labels

[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.

 

[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 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 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.

 

[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