Replace Fuction ?

[naobao]

I want to convert some data like this in a query
0K9F-5-L-997-01 >>> 0K9F5L99701
4W7Y-0-99-99-99 >>> 4W7Y0999999

I use replace fuction, but it not works and show error!
man_code: Replace([item_code],"-","")

It is the replace fuction not works in access?
How can I fix this problem?

 

[Isaac]

What's the error

 

[The_Doc_Man]

Isaac beat me to it. You can START to fix the problem by telling us the error.
But also, show us how you were using it by showing us the whole line of code in which you tried it but it failed.

 

[arnelgp]

what is [item_code]?
numeric with Lookup?