Finding duplicate data from two columns

[alcorp]

Hi,



I am trying to find duplicate data from two columns and I want to query the all the duplicates. I tried the query wizard but it only finds duplicates in the column itself. I am trying to compare the columns together and see what is found in column A that is also found in column B and also Vice Versa.

I have several thousands of rows so anything will help. I tried using the query tables and the sql code but I can't figure it out. Thanks.

[June7]

Maybe:

SELECT * FROM tablename WHERE A = B;

[alcorp]

When I tried that, it said it was missing parameter value

[June7]

Sorry, I rushed my response.

SELECT Table1.* FROM Table1, Table1 AS Table1_1 WHERE (((Table1.A)=[Table1_1].[B]));

Of course, need to use your actual table and field names.

However, can each value occur more than once in each of the columns? If so, might need to look at another approach.