how to specify decimal on query

J

Joe Au

I create an append query on Access as follow:

Parameters p_field1 decimal;
insert into table1 (field1) values ([p_field1]);

The field1 is a decimal field with 2 decimal points. How do I specify its
type?
Thanks.

Joe.
 
B

berk

Not sure if I understand, but whenever you use decimals,
you should specify the type as double
 
J

John Vinson

Not sure if I understand, but whenever you use decimals,
you should specify the type as double
Click to expand...

.... or Single, or Currency, or (if you trust the rather buggy new
datatype) Decimal. Double is useful but it's not the only choice! In
fact, Currency fields are probably best for many uses: 4 decimal
places, range into the trillions, and no roundoff error.
 
J

Joe Au

Thanks you.


John Vinson said:
... or Single, or Currency, or (if you trust the rather buggy new
datatype) Decimal. Double is useful but it's not the only choice! In
fact, Currency fields are probably best for many uses: 4 decimal
places, range into the trillions, and no roundoff error.
Click to expand...
 
Top