MS-Access user
Hi All,
Is there n e way to get the substring from the result of query in MS-Access?
Please help me, waiting for your answers.
bye bye,
take care all of you.
"when one door of happiness closes
another opens;but often we look so long
at the closed door that we do not see
which one has opened for us "(Helen Keller)
Peter J. Boettcher posted this at 14:19 — 1st January 2002.
They have: 812 posts
Joined: Feb 2000
Sorry for the late reply. You should be able to use the Mid() function in Access which will give you the same sort of functionality as SubString()
Mid(string,start,length)
Length is optional.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.