First letter in field match

P

PamH

I am trying to find common records in two tables.

I need to find all records with same lastname and match the first
 
K

KARL DEWEY

Use this in the design view grid criteria row under the field ---
Like [Enter first letter] & "*"
 
J

John W. Vinson

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]
 
Top