Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Find similar names in two tables

    I have two tables - one with new imported data from exel



    I have to see if any of the names in the new are the same as they are in the first original table - do they match

    Not sure the correct way to do this using a query and the two tables - please help

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    note the names have to be "like"

    so if field value xyz is matches like value xyza then show

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

Similar Threads

  1. Replies: 3
    Last Post: 08-08-2012, 03:15 AM
  2. Similar Names
    By Christine Boissoin in forum Queries
    Replies: 4
    Last Post: 09-09-2011, 07:24 AM
  3. Finding like or similar names
    By Laurie B. in forum Queries
    Replies: 1
    Last Post: 08-14-2011, 07:24 AM
  4. Finding similar names between two tables.
    By Laurie B. in forum Access
    Replies: 1
    Last Post: 07-15-2011, 03:21 PM
  5. Customer Entry/Find Duplicate/Similar names
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-27-2010, 09:20 PM

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