MS Access Create column with Double data type

Question

I Want to Create a table which contains the column of type DOUBLE real Number. I Can find the datatype Number in the Table Design view, But no Double or single, Float.. how to achieve..?

also i need the SQL Query for creating table with Double column and DATA types list which can be used in QUERY to create table. In the design view there is limited no. of Data types..

Answer 1

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

Answer 2

You can of course create columns of type "Double" (and others) with the table designer, too.

Simply select "number" as datatype and then look at the lower half of the table designer where you can specify the exact type (which is by default "Long Integer" if you have chosen "Number" as basic data type).

In fact Access also uses a single list of datatypes as any other database, but the table designer "groups" such datatypes into basic data types.