matching on first 4 characters of a field

Lawrence · Jan 31, 2004

I need to match two fields (first name) but I only want to
consider the first 4 characters of each field for the
match to be true. Is there a way to do this?

Lawrence

Duane Hookom · Jan 31, 2004

You can remove the join lines and set the criteria under
MatchIt:Left(FieldA,4)
Left(FieldB,4)

Lawrence · Jan 31, 2004

Thanks, Duane, worked like a charm.

-----Original Message-----
You can remove the join lines and set the criteria under
MatchIt:Left(FieldA,4)
Left(FieldB,4)

--
Duane Hookom
MS Access MVP

.