Don't want duplicate names

C

ClaireView

I've tried to apply answers I found on this newsgroup, but I'm just not
getting it. Sorry if this is a very basic question.

I have a list of clients with FN, LN, SSN, address, and date they came to
our office. I've done a query and found some people came to the office more
than once in a month. I only want to know the names of who came at least
once, and not duplicates if they came more than once. Thanks for your help.
 
J

John Vinson

I've tried to apply answers I found on this newsgroup, but I'm just not
getting it. Sorry if this is a very basic question.

I have a list of clients with FN, LN, SSN, address, and date they came to
our office. I've done a query and found some people came to the office more
than once in a month. I only want to know the names of who came at least
once, and not duplicates if they came more than once. Thanks for your help.
Click to expand...

Set the Unique Values property of the query to True; or, if you're
including the date that they came in, make it a Totals query by
clicking the Greek Sigma icon and group by FN, LN, SSN and Address.
Use the Where operator for the date (since you don't want to see two
records, you obviously can't display multiple dates; using Where will
filter the data to the current month but not show the date).

John W. Vinson[MVP]
 
C

ClaireView

Thanks, John. I DID have to include the date field, which is why I couldn't
just set "Unique Values" to true. Your answer was clear and I should be able
to get it from here. Thanks for responding!
 
D

Don

ClaireView,
I have a similiar problem could you please post the sql code that you used.
Thanks,
Don
 
Top