Rounded up values

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

Guest

help, how to stop access from rounding up values you enter in a table?
i enter this 458.59 and access changes it to 459.00. I have the format set
to standard and the decimal places set to auto and i have tried setting it to
2 but the same thin happens. HELP pls!
 
Mr. Capuchino said:
help, how to stop access from rounding up values you enter in a table?
i enter this 458.59 and access changes it to 459.00. I have the format set
to standard and the decimal places set to auto and i have tried setting it to
2 but the same thin happens. HELP pls!
Click to expand...


What is the data type of the field?
 
Change your field type from Number- integer to Number-double

Ed Warren
 
You must log in or register to reply here.

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

Autoformats 1
Excel Stop Excel from displaying rounded values 4
Rounding in a Currency Field 4
Access stripping decimal places in query 1
Lookup - Combo Box 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Automatic rounding? 1
Unwanted Numbers Rounding 6

Back
Top