decimal - off by one


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
 
Ad

Advertisements

J

John W. Vinson

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

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
 

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

Top