Comparing Records from the same table using Access 2003

[Rdailey]

Hello,

I am trying to compare record values in one column to the next column within the same table. I have tried everything that I can think of and still have not achieved the desired result. The values contained in the fields are "text" values. I am simply trying to see if Jane Smith which is the test entered in column 1 is also in column 2? I used Jane Smith as a example but actually it would be a search on all values in Column 1 to see if there is a match and if so how many matches in column 2.

I hope someone can help me. I am under a strict deadline and cannot figure this one out.

Thanks
Robin

[nico5038]

Hello,

I am trying to compare record values in one column to the next column within the same table. I have tried everything that I can think of and still have not achieved the desired result. The values contained in the fields are "text" values. I am simply trying to see if Jane Smith which is the test entered in column 1 is also in column 2? I used Jane Smith as a example but actually it would be a search on all values in Column 1 to see if there is a match and if so how many matches in column 2.

I hope someone can help me. I am under a strict deadline and cannot figure this one out.

Thanks
Robin

Looks to me you want to find all "Jane Smith"'s in column 2 matching with the name in column 1.
To do this open the query editor and place the table twice. (One will show with tablename_1)
Now connect Column1 with Column2 so the tables are JOINed.
Now place Column1 from the first table and Column2 from the second and see the result.

Getting the idea ?

Nic;o)