Results 1 to 2 of 2
  1. #1
    Laurie B. is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2011
    Posts
    10

    Finding similar names between two tables.

    Good Afternoon,



    I have two tables linked by Name. The names are not unique and may have Corp., or Corp. or Corp in one table and Corporate spelled out in another table. Some may have a hypen separating names etc..

    I would like to create a query to see all the records and fields from the table on the left and only a few fields from the second table on the right if the names are similar and state matches.

    I was able to create the query but my results are for the exact matches on the name.

    Thank you for your assitance.
    Laurie B.

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Something like...

    Code:
     
    SELECT [Table1].*, [Table2].*
    FROM [Table1], [Table2]
    WHERE [Table1].[Fiiel1] LIKE
    [Table2].[Field1] & "*";
    Though even that is going to produce results that are going to have to be eye balled and is not fail safe.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-24-2011, 03:14 AM
  2. Customer Entry/Find Duplicate/Similar names
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-27-2010, 09:20 PM
  3. Finding Tables
    By Rick West in forum Access
    Replies: 1
    Last Post: 01-06-2010, 10:41 AM
  4. Replies: 5
    Last Post: 08-07-2009, 05:23 PM
  5. Replies: 1
    Last Post: 07-07-2009, 01:00 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