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...