I'm getting a message box when I run the SQL... undefined
function 'Replace' in expression.
How do I get around this? Thanks
Mark,
It's considered polite to post replies to an ongoing thread rather
than a new message; and if you must post a new message, post some of
the context. There are hundreds of messages every day here; we who
volunteer our time can't be expected to remember every single thread
or to go to Google to find old ones, especially on such scanty
information!
What version of Access are you running? Replace() was not available in
A97 at all; it was available in 2000 but could not be used in queries.
If you have A2000 you can create a new Module (named Getarounds or
Utilities or anything other than QReplace) and edit into it:
Public Function QReplace(sIn As String, sOld As String, _
sNew As String) As String
QReplace = Replace(sIn, sOld, sNew)
End Function
You can then use QReplace in your query instead of Replace.
