Function Replace Not Defined

[Dan Pinheiro \(Hotmail\)]

Hi All,
I´m trying to run the code bellow in Access 2000/XP:

.... SELECT
'2'+Right('000000'+LTrim(P3.PRODUTO),6)+Right('0000000000000000000000000000'+LTrim(Replace(P3.PRECO_VEND,',','')),18)+'000'+Format(P3.DT_CAD_PRO,"dd")+Format(P3.DT_CAD_PRO,"mm")+Format(P3.DT_CAD_PRO,"yy")
AS Expr1 ...

It doesn´t work, appear the message "Function Replace Not Defined in
expression".

Running in the Access 2003 it works fine.

What function I have to use?

Tks in advance.

Dan Pinheiro
Rio de Janeiro - Brasil.

 

[Beth Melton]

You can't use the Replace function in a query in Access 2000 however
it can be used in Access VBA.

If you need help with this then you may want to post in one of the
Access newsgroups since that's where the Access experts tend to hang
out. Around here you gotta wait for someone who knows Access to
stumble upon your post.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/