By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Comparing Records from the same table using Access 2003

P: 1
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
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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.