Results 1 to 4 of 4
  1. #1
    201034 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    2

    Matching or Dlookup?

    Hi there, I hope you guys can help me out.

    I'm trying to match 2 data fielfs from 2 tables that Don't match 100%.

    Example :

    [tblCOMPANY,NAME] [tblFIND,NAME]
    Airbus SAS LG
    LG LCC
    Vodafone

    How can I match both NAME fields if the value doesn't match one on one?


    Is it possible to macht on the first 2 characters?
    VBA is also fine.

  2. #2
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    You can use wildcards in a filter.
    In my databases if you would look for "Joh" then records would return ;

    "John"
    "Johnson"
    "Johanson"

    Is this what your looking for ?

  3. #3
    201034 is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    2
    But than you woukld to need hardcode "Joh". I don't want to
    hardcode 50K of names.

  4. #4
    dbdesign is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2012
    Location
    CT
    Posts
    5
    How about a query with Len function in a query? Len = 2 or Len = 3, etc

    Query1:
    CompanyNameLen3: Len([tblCompany].[Name],3)

    Query2:
    FindNameLen3: Len([tblFind].[Name],3)

    Query3: has Query1 and Query2 matched by those fields.

    The above actually sounds messy. Especially with lots of data and lots of data that starts with the same three letters. I can think of lots of other ways to still use the LEN function. Like if I have the user type the name in a form and have a query return all the records that begin with the first three letters.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-24-2011, 08:01 AM
  2. Replies: 1
    Last Post: 08-11-2011, 11:33 AM
  3. Matching between 2 tables
    By slevin in forum Access
    Replies: 1
    Last Post: 06-16-2010, 07:28 AM
  4. String Matching
    By tuna in forum Programming
    Replies: 1
    Last Post: 05-16-2010, 12:22 PM
  5. Matching Query Dates
    By rgwynne in forum Queries
    Replies: 1
    Last Post: 08-13-2009, 05:23 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