Query on Dulpicates- Need some help!!

[dr_shiva29]

Hi All,

I have a table in which there are 4 columns and I need to create a query which can only present me duplicate entries between 2 of these columns. Something like the below:

Client # Self # Items Type
123 980 3 A
456 735 1 B
980 285 9 K
342 123 6 M

The query should be able to give me a result like:

Client # Self # Items Type
123 123 6 M
980 980 3 A

The Duplicate Query in Access, as such allows me to extract duplicates only if the data is in one column but I am in a fix now on how to identify duplicates across columns.

Any suggestions?

 

[Beetle]

A query like the following shoul do the trick;

SELECT A.Client, B.Self, B.Items, B.Type
FROM YourTable As A INNER JOIN YourTable AS B ON A.Client = B.Self
ORDER BY A.Client;

BTW - Type is a Reserved Word in Access and should not be used as the name of any user defined object (like a field, etc.). For more on Reserved Woprds, see this link.

 

[dr_shiva29]

A query like the following shoul do the trick;

SELECT A.Client, B.Self, B.Items, B.Type
FROM YourTable As A INNER JOIN YourTable AS B ON A.Client = B.Self
ORDER BY A.Client;

BTW - Type is a Reserved Word in Access and should not be used as the name of any user defined object (like a field, etc.). For more on Reserved Woprds, see .

Bingo! This worked!!! Thanks a ton, Beetle.