468,525 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,525 developers. It's quick & easy.

Comparing Records from the same table using Access 2003

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
Oct 5 '07 #1
1 2277
nico5038
3,079 Expert 2GB
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)
Oct 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Riegnman | last post: by
3 posts views Thread by Michael Thomas | last post: by
2 posts views Thread by HB2 | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.