link two data fields one is subset of another

F

Frances Yang

Hi,
I have two data fields. Field1 is 5 character length and Field 2 is 3. I
need a query in which Field2= first 3 character of Field1. How do I do that?
Thank you for your help.
 
J

John Spencer (MVP)

One method is to use like and wildcards in your criteria.

Field: Field1
Criteria: Like Field2 & "*"
 
Top