G Guest Jul 3, 2007 #1 I am trying to find common records in two tables. I need to find all records with same lastname and match the first
I am trying to find common records in two tables. I need to find all records with same lastname and match the first
G Guest Jul 3, 2007 #2 Use this in the design view grid criteria row under the field --- Like [Enter first letter] & "*"
J John W. Vinson Jul 3, 2007 #3 I am trying to find common records in two tables. I need to find all records with same lastname and match the first Click to expand... Create a Query joining the two tables on Lastname. As a criterion under the FirstName field in the second table put LIKE Left([FirstTable].[FirstName], 1) & "*" This should find "Jane Smith" as a match to "Josephina Smith"; you'll likely get multiple matches for each name, of course. John W. Vinson [MVP]
I am trying to find common records in two tables. I need to find all records with same lastname and match the first Click to expand... Create a Query joining the two tables on Lastname. As a criterion under the FirstName field in the second table put LIKE Left([FirstTable].[FirstName], 1) & "*" This should find "Jane Smith" as a match to "Josephina Smith"; you'll likely get multiple matches for each name, of course. John W. Vinson [MVP]
