How do I remove 1 of the duplicates from my customer labels query?

[Dustin]

I buitlt a query so I can put my customers names through the label wizard.
But I can't figure out how to keep out the duplicate customer names. Is there
a way to keep one of the duplicates out?

Thanks
Dustin

 

[KARL DEWEY]

Try a TOTALS query if all fields are identical. But if something is
different it will appear more than once.

 

[John W. Vinson]

I buitlt a query so I can put my customers names through the label wizard.
But I can't figure out how to keep out the duplicate customer names. Is there
a way to keep one of the duplicates out?

Try a Totals query. Group By the field or fields which constitute a
duplicate - I'd be leery of using the customer name since different
people can have the same name, maybe use customer name and telephone
number, or address, depending on your table structure.

Select First as the Total row for each of the other fields to
arbitrarily pick one of the records (the first in disk storage order)
for that customer.

John W. Vinson [MVP]

 

[Dustin]

I understand the Totals query so that it will show Group by, but how do I use
that to seperate the two. Is their something I need to write in the criteria
to seperate them?

Thanks Dustin

 

[KARL DEWEY]

No, it rolls the duplicates into a group and eliminates displaying them
multiple times.

 

[Dustin]

Hey thanks, I got it to group them. I am wondering how to get the label
report to ask me if I want to print off just a indvidual label or all of
them. Is there a way to do that?

Thanks

Dustin

 

[KARL DEWEY]

Put criteria in your report like this --
Like "*" & [Which label to print OR press ENTER for all] & "*"