Create Table query help???

[Vachaun22]

I know this is going to sound really stupid, but for some reason I can't find the answer anywhere on the net.

I'm running this SQL command on an Access 2000 database:

CREATE TABLE F_UNITS (FU_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY, FU_UNIT_NUMBER INTEGER, FU_PERMIT_NUMBER INTEGER, FU_WEIGHT INTEGER);

This is all fine and dandy, but how would I make say a floating point (or single/double) data type, or a long integer on a field? For some reason I can't find a whole lot of information on running a Create Table command against an Access database, and I can't find the key words to define the different data types.

Any help?

 

[PHV]

for single use REAL
for double use FLOAT

Search the JetSQL help file for "Data type SQL"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[traingamer]

See also

http://support.microsoft.com/kb/291539/en-us

for Microsoft's brief description.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill