Rounding up in an append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
We had already changed it from integer to decimal for this reason. Shouldn't
it work as a decimal type?
 
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
 
Back
Top