using substr in Access query does not work

[trialerror]

I have a query in Access 2002, which is using the substr function, as in ---substr(owner,1,9)
but Access is throwing an error and saying "undefined 'substr' function in expresion."
Any suggestions?
Thanks

 

[earthandfire]

In Access you need to use the Mid function - same syntax

 

[traingamer]

Thinking of the Mid() function?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[trialerror]

Thanks-could not find it anywhere!It worked.