Data Type Equivalents: Ms Access Tables ↔ 'Create Table' Queries ↔ Odbc Sql

Creating a Table but getting Syntax error in field definition

You can use Currency to get you over this detail.

Create Table Order_Line
(
Order_Num Char(5),
Item_Num Char(4),
Num_Ordered Currency,
Quoted_Price Currency,
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:

http://allenbrowne.com/ser-49.html

Related Topics