Rounding up in an append Query

R

rdr65

I have a similar problem to the one copied and pasted below. I have the data
type set as a decimal, precision as 6, scale as 2 and decimal places as 2.
For some reason it rounds everything to a whole number (.86 up to 1.00, 1.5
up to 2.00). Anyone know what the problem is?
 
O

Ofer

Check the field type you are appending to, if the type long or int it will
round the number, this type doesnt except decimal places.
Change it to double or single
 
R

rdr65

We had already changed it from integer to decimal for this reason. Shouldn't
it work as a decimal type?
 
O

Ofer

No, change it to double or single
Try and input a number directly to the table with decimal places and youll
see that the number will round
 
Top