Jet sql query problem / Decimals??

[test1357]

Hello everyone,

My problem is that I want to create a table with a field of data type decimal with a scale. As you know decimal data type isn't supported in ms access jet engine. Here is an example.

create table test (
field1 integer primary key not null,
field2 varchar(20),
field3 decimal (10,2))

Can I use another data type instead of decimal and assign it a scale??

Thanks..

Have in mind that I don't want to use design view of table or vba. Just sql.

 

[Steve101]

In Access97, the closest data type is Number, Field Size setting of Double, and Decimal points set as required. Check online help for more details regarding precision.

In Access2000, Decimal field size is supported.

Hope this helps,


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)