matching on first 4 characters of a field

[Lawrence]

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]

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

 

[Lawrence]

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





.