Changing dot (period) to comma - decimal separator

[jaworski_m]

Hello,

I imported a table where one of the fields has a dot as a decimal separator. Usage of dots results in errors everywhere calculations are performed.
How can dots be replaced with a comma using either an update query, VBA or other method?

Thank you for hints.

[amrut]

Have a look at the Replace function, can be used in queries as well as VBA. http://www.techonthenet.com/access/f...ng/replace.php