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"


Look here for a list of the various Access field type names and constants:

Related Topics

Leave a reply