Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Validating tables


    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

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    This is a notoriously difficult problem, and not one that a simple query is likely to solve. There are mailing list management software packages out there that do a decent job.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums