Finding Duplicate Values on the Same Record

  • Thread starter Thread starter Ting
  • Start date Start date
T

Ting

I'm looking for a way (a query I would guess) to look at a
record in a table (or another query) and tell me if 2 of
the values are the same (or duplicated). For example, the
information gathered asks for a daytime phone number and
an evening phone number. This info is all under one record
associated with a client. I want to make sure that I can
see who is using the same number for day and night. I know
I can filter, but I want a very automated process that
anyone can run simply by invoking the query or macro.
Thanks.
 
I'm looking for a way (a query I would guess) to look at a
record in a table (or another query) and tell me if 2 of
the values are the same (or duplicated). For example, the
information gathered asks for a daytime phone number and
an evening phone number. This info is all under one record
associated with a client. I want to make sure that I can
see who is using the same number for day and night. I know
I can filter, but I want a very automated process that
anyone can run simply by invoking the query or macro.
Thanks.
Click to expand...

A Query can do this very readily. But just HOW depends on how your
table is structured! Are these multiple fields, [HomePhone] and
[WorkPhone]? or are they in multiple records in the table?

John W. Vinson[MVP]
(no longer chatting for now)
 
-----Original Message-----
I'm looking for a way (a query I would guess) to look at a
record in a table (or another query) and tell me if 2 of
the values are the same (or duplicated). For example, the
information gathered asks for a daytime phone number and
an evening phone number. This info is all under one record
associated with a client. I want to make sure that I can
see who is using the same number for day and night. I know
I can filter, but I want a very automated process that
anyone can run simply by invoking the query or macro.
Thanks.
Click to expand...

A Query can do this very readily. But just HOW depends on how your
table is structured! Are these multiple fields, [HomePhone] and
[WorkPhone]? or are they in multiple records in the table?

John W. Vinson[MVP]
(no longer chatting for now)
.
Every record requires these to fields to be filled out in
Click to expand...
the same table. So there are 2 different fields with
multiple unique values based on the customer name.
Click to expand...
 
Every record requires these to fields to be filled out in
the same table. So there are 2 different fields with
multiple unique values based on the customer name.
Click to expand...

If the fields are named HomePhone and WorkPhone, you can create a
Query based on the table with a critirion on WorkPhone of

=[HomePhone]

This query will display all records where the two numbers are the
same.

John W. Vinson[MVP]
(no longer chatting for now)
 
That did it. Thanks.

-----Original Message-----
Every record requires these to fields to be filled out in
the same table. So there are 2 different fields with
multiple unique values based on the customer name.
Click to expand...

If the fields are named HomePhone and WorkPhone, you can create a
Query based on the table with a critirion on WorkPhone of

=[HomePhone]

This query will display all records where the two numbers are the
same.

John W. Vinson[MVP]
(no longer chatting for now)
.
Click to expand...
Click to expand...
 
Back
Top