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).
 
Back
Top