I want to use Microsoft Access SQL (version 2003) to create a table.
It works fine *EXCEPT* I can't seem to create a decimal number type!

I'm trying to do this in the Query/SQL pane:
CREATE TABLE [TEST] ([ID] Long NOT NULL, [MyTextField] Text (2),
[MyDecimalField] Decimal(10,6))

Everything works except the Decimal declaration. I've tried changing
the word 'Decimal' to 'Double', 'Numeric', etc. but no dice. I need
that field to have a Precision of 10 and a Scale of 6. Can someone
please tell me the proper syntax? I've searched and searched but can't
find exactly what I'm looking for.

Thanks!

My recollection may be somewhat dated, but in the past Access did not
support a decimal/numeric datatype, which they highlighted under their
items of ANSI SQL noncompliance.  The MS suggested "workaround" is to
use the money datatype, which is a bit cheesy, but does offer 4 digits
of fixed precision to the right of the decimal point.

regards, mathtalk-ga