Query based on 6th character

[Guest]

I have a query that I would like to use based on the 6th character. The
first 5 characters can be whatever, but the 6th character needs to match
whatever is entered. I know how to use the "like" criteria I just don't know
how to make it count over the 6 characters. Any suggestions?

 

[Michel Walsh]

fieldName LIKE "?????a*"


as example, for spotting an a.


Can also use

"a" = MID( fieldName, 6, 1 )



If the query ever becomes too slow, maybe you should consider to normalize
your data.



Hoping it may help,
Vanderghast, Access MVP