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.