Results 1 to 3 of 3
  1. #1
    lolamarie106 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    2

    My query criteria only matches the beginning and not the middle or end


    I have data in field1.table1 and data in field1.table2. I didn't join the tables but there is a one to many relationship between field1.table1 and field1.table2. In my query, I'm using the two fields mentioned from the two tables and my criteria under the field1.table2 is Like [field1.table1] & "*". Now, the results are good but it's not showing where the name doesn't start but is contained within the field and I'm not sure how to write this. I attached two pictures...the first is the results and the second attachment are the fields that it didn't find but that I want to find. I hope this makes sense...
    Attached Thumbnails Attached Thumbnails Results from Query Criteria.jpg   Results missing from Query Criteria.jpg  

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try

    Like "*" & [field1.table1] & "*"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    lolamarie106 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    2
    That's too many records....it's finding partial to partial matches. I still need it to keep the full match from field1.table1 but exact and partial matches to field1.table2

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

Similar Threads

  1. Replies: 7
    Last Post: 02-29-2016, 06:13 PM
  2. Replies: 4
    Last Post: 08-01-2014, 09:20 AM
  3. Replies: 6
    Last Post: 06-24-2014, 10:09 PM
  4. Replies: 1
    Last Post: 01-30-2013, 03:27 PM
  5. Replies: 3
    Last Post: 05-08-2011, 12:55 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