Replace function not found

  • Thread starter Thread starter yuner
  • Start date Start date
Y

yuner

I created a query in Access XP and open it in Access
2000. It tells me the replace function in not define. But
I thinke, the replace function (replase a string to
antoher) should be included in anyversion of Access.

Any idea? How I can fix it?

Thanks a lot.
 
yuner said:
I created a query in Access XP and open it in Access
2000. It tells me the replace function in not define. But
I thinke, the replace function (replase a string to
antoher) should be included in anyversion of Access.
Click to expand...

For some silly reason Access 2000 has a few functions that do not work in
queries. This is particularly strange since even user-defined functions work in
queries just fine. Replace() is one of these and the work-around is to create a
user-defined wrapper function and use that instead.
 
Back
Top