Replace commas and points in a field

[koengi01]

Hello,

I have a Access db, in which I import a textfield.
The Field Value contains the value eg. 10,800.00.
I want to replace this after importing the file in 10800.00

Can anyone help me with this.
At the moment I'm using manually find and replace.

Rgards

 

[lupins46]

Update the text field to:
format(cdbl(mytextfield),"0.00")

 

[koengi01]

Hi Lupins46,

Thx for your answer

If I run this as an update query, the value 6.14 is updated to 614 instead of 6,14.

I'm I doning something wrong?

Regards Koen

 

[lupins46]

Your original post indicated that you were using a '.' as the decimal separator. If you are now using a ',' then you need to change the format expression to use 0,00

 

[koengi01]

Sorry, I mistyped.

And how do I do this???

I also tried to take a look at the Replace() function but in my helpfile (Acc 2000) there is nothing in it

Thx Koen