Solved Change a fild datatype from double to decimal

[mansied]

Hello, I want to change the data type of a field from double to decimal .
This SQL code
ALTER TABLE **tablename** ALTER COLUMN [**myfield**] DECIMAL(6,2)

says syntax error and doesn't let me save it.
Does anyone have a suggestion about how to change it?

 

[arnelgp]

using SQL statement on Decimal, you can't.
Is it possible to alter column to decimal in MS Access 2007+? - Stack Overflow