Why is currency field not saving pennies??

[Grezzo]

I have a currency field that is not saving pennies. (cents if you're Americian i suppose) if i put in pence it rounds it to the nearest pound.

I have tried setting the decimal places to "2", but that makes no difference

the table is called invoice

this also happens with the invoice form (i suspect for the same reason)

The database can be downloaded from:
http://www.tapestriesdirect.com/Garage.mdb (996KB)
or if you can unzip (who can't?!?)
http://www.tapestriesdirect.com/Garage.zip (86.1KB)

Cheers for any help

Graeme

 

[trucktime]

Currency

Change your fields from Long Integer to Double.

 

[Pat Hartman]

Currency is a format as well as a data type. You will be much happier with your results if you use the currency data type rather than the double precision data type. You will find that when using a double precision data type 1.01 * 1 is not always 1.01 but with currency (which is fixed point) you will never have that type of rounding error.