Rounding problems...

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

Guest

How can I get the table to stop rounding? I have it set on Long Integer with
2 decimal places, but when I enter decimals it rounds them in the table and
in reports... Help! : )
 
As posted very very very oftne (please search for an answer before posting a
new thread in the future) INTEGERS do not have decimals. An integer is a
whole number.
 
A "Long" number is an integer. Integers have no decimal places.

If you need decimal places, you need a different data type -- try currency,
single or double.

Good luck

Jeff Boyce
<Access MVP>
 

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

Access stripping decimal places in query 1
Digits on right of Decimal points 1
Excel Stop Excel from displaying rounded values 4
round function not work property in access 10
stop the rounding 4
wHY DO ALL MY NUMBER FIELDS KEEP ROUNDING IN ACCESS 2
Excel Excel 2007 won't stop rounding down my formula results! 5
Number field...how does one show decimal places ? 2

Back
Top