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