decimal - off by one

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I hope someone can help me. When I run the query, the number show 3.5000. When the number round to 4 but I have 3. It should be 4.

Is there a reason why I did it wrong.

Thanks
 
Hi,

I hope someone can help me. When I run the query, the number show 3.5000. When the number round to 4 but I have 3. It should be 4.

Is there a reason why I did it wrong.

Thanks
Click to expand...

Ummm...

You can see your computer. We cannot.

"The query"? What's the query? Could you post the SQL?

What's the calculation? What's rounding the number?

Note that 3.4999999999999 will round to 3, even if it displays as 3.5000 due
to a format specification (I'm assuming Double datatype; is it?)
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top