Replace function not found

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.
 
R

Rick Brandt

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.
 
Top