How do I stop a currency field from rounding up?

G

Glenda

I'm using MS Access 2002. The database is very simple. The field data type
is a "Number" and the format is "Currency" with 2 decimals. For some reason
it rounds up. I checked the properties and don't see any that will make a
difference.
 
R

Rick Brandt

Glenda said:
I'm using MS Access 2002. The database is very simple. The field
data type is a "Number" and the format is "Currency" with 2 decimals.
For some reason it rounds up. I checked the properties and don't see
any that will make a difference.
Click to expand...

Change the TYPE to currency. It is likely that you currently have the Field
Size set to Integer or Long Integer and those do not hold fractional values
(regardless of the format setting which is just for display).
 
Top