471,082 Members | 802 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

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 2494
nico5038
3,080 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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.