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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding up .5 in a calculation 1
Sum and DateDiff 2
Rounding up to 2 decimals 4
fractional part of value returns multiple digits 3
round function in query 0
round up decimal to next whole number 5
Show whole dollar amount only 2
Update query on a query on the latest date 2

Top