i'm trying to get the decimal number to NOT round up

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

Guest

i need to input decimal number. (1.5) it keeps rounding up to 2. i fixed
the decminal to 1 on the table, query, and form. i dont not want to number
to round up at all. what am i missing.
 
What data type is the field. It should be Single or Double to handle
decimals. Not Byte or Integer or Long.
 
The field type in the table is probably set to Long type this type round the
number, set the field type to double
 

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

Found a Bug or Error in Access 2002-2003 Round Function 3
How do I prevent a number from rounding in Access? 2
Round Up a Decimal 6
Stop Rounding in Forms 2
Numbers are automatically rounding up in Tables, Forms, etc. 3
Round up number 2
Query Calculation Decimal Point Removal 7
Access keeps rounding down... Decimal 5

Back
Top