Hello,
I don't know if this has been answered before but I am trying to validate two tables. I have 2 address fields that are from different people. One person may enter the address as 1 Main Street while the other may enter it as 1 Main St. How do I get the two entries to recognize each other in a query? I have the relationship between the Address fields and when I query them neither show up because they are different. Any help would be great. Thank you