SQL Type DECIMAL

[rmuller2]

this is not accepted by Access:

CREATE TABLE test (
DecimalField DECIMAL(7,3);
)

What's wrong? In the documentation you can find that the DECIMAL type is supported and that the precision and scale
are variable??

Thanks for helping!

Ronald

 

[cmmrfrds]

The decimal data type is transitory in that you cannot actually use it as a data type in a table definition. You can move a number to a variant data type and then use decimal to perform calculations but to store the result try a "number" data type. The "number" data type will probably work for your needs anyway.