Creating a Table but getting Syntax error in field definition
You can use Currency to get you over this detail.
Create Table Order_Line
Primary Key (Order_Num, Item_Num)
Currency is like Decimal (15,4)
I think your original sql statement would have worked in previous versions of Access.
The Manual Query Designer will still allow you to change the decimal places per field for Number and Large Number.
MS Access Create column with Double data type
The following Access SQL CREATE TABLE statement creates a table with a field of type "Double"
CREATE TABLE Gord (dblField DOUBLE)
Look here for a list of the various Access field type names and constants: