Change decimal seperator in VBA to dot

  • Thread starter Thread starter Helge
  • Start date Start date
H

Helge

In need to run an Updatequery in Vba:

UPDATE tblSParametre SET Lønnsomt = 1, Nåverdi = 23100,6166,
BalPrisOlje = 16,5917, BalPrisGass = 0,0166, SluttårCutoff = 2020
WHERE SID=54 AND ProsjektID=2;

I can not use Nåverdi = 23100,6166. I has to be: Nåverdi = 23100.6166

How can I change this comma to dot?

Helge
 
On Mon, 11 May 2009 05:31:29 -0700 (PDT), Helge

You could use the Replace function:
sql = "update tbl..."
currentdb.execute Replace(sql, ",", "."), dbFailOnError

-Tom.
Microsoft Access MVP
 
Back
Top