sub string command in Access query

[Ben Zimmerman]

I have Microsoft 07. Use Access a lot.
Used dBase, dbaseII, dbaseIIIA, dbasePlus and etc.

Used substr and need help on structure to use in Access query

Thank You
Ben

[NeoPa]

I think the answer to the question you meant to ask is Mid().

If not, post the question and we'll see what we can do to help.