rounding up amount

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

Guest

I have a field which is for amount (not currency) and I have it as :
Field size: long integer
Format: general number
decimal: auto
I want to be able to type and show numbers with one or 2 numbers behind the
decimal but it automatically takes the decimal and numbers after it out. I
have tried everything available but it always takes out the decimal part out.
Tx
 
The integer types (including Long and Byte) can only store whole numbers.

Use the Currency field type, unless you need to handle trillions of dollars.
 
Use Currency for accuracy but it defaults to the $ prefix. Use Double or
single (allows decimal places).
 

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

simple formatting 18
Access stripping decimal places in query 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Number of decimal places ... 7
Currency 4
Currency and the number of decimal places 3
Editing monetary amounts 4
Export Table Data To Formatted Text File 2

Back
Top