--------------------------------------------------------------------------------

What is the syntax for creating a Decimal field using the CREATE TABL
statement? For example, this works for a Double field:

Currentdb.Execute "CREATE TABLE aTable1 (f1 DOUBLE)"

But this does not work for a Decimal field:

Currentdb.Execute "CREATE TABLE aTable1 (f1 DECIMAL)"

Neither does this work:

Currentdb.Execute "CREATE TABLE aTable1 (f1 DECIMAL(10,2))

--
Alle