I am using Access 2007 and 2003. I would like a query to detect if one field contains certain
sequential letters from another field
Field1:------------- Field2:
Express 27---- --- Alsberg Express 27
Santa Cruz 27-----Bill Lee Santa Cruz 27
Santana 22 -------Merit 25
etc.
The query would then take, say the left 3 letters of field1 (Exp, San etc), and filter the query
for Field2 entries that contained those 3 letters in the same sequence. Possible? Any help
much appreciated.