query part of string

  • Thread starter Thread starter jeff lane
  • Start date Start date
J

jeff lane

How do I query a string of 7 characters when the part I want to query is
always the 3rd and 4th letter.
I assume it requires wildcards * but all I can manage is to get the two
digits I want from anywhere in the string, not from only 3/4 position.

e.g in string MX03ABC I want to be able to pull out all of the records with
03 in that position not the ones with A034XYZ

help please.
 
Dear Jeff:

I recommend you use the Mid() function, as in:

Mid([YourColumnName], 3, 2)

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top