Access is changing my data upon entry!

[kmclane]

I am reposting this with a better subject, I realized that my first post subject was inaccurate.
I have a field in a table that is set to Currency, 5 decimal places, but when I enter .08825 it changes it to .08820. I can't figure out how to change this behavior, it is messing up my totals. Any ideas?
Thanks, Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[kerplunkitt]

Hi Ken
Change the field Data type to Number.
Then change the field size to Decimal.
Then set the scale to 6.
Make sure the decimal places is still at 5.
Then it will work..
If you have a form then you can set the text box of the form to display in currency if you wish.
Hope this helps

Regards
'viper

 

[pbrodsky]

This is from the Access Help file.

"Use a Currency field to prevent rounding off during calculations. A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right. A Currency field occupies 8 bytes of disk space."

It doesn't appear that you can use a "currency" data type with 5 decimal places

 

[hobman]

Mitch,

what you need to do is go to the table that contains the field in design view and change the field size to double, the format to standard and the decimal points to however many you usually use.

hop this helps,
hobman

 

[kmclane]

Thanks, that solved it. I was just starting to dig in the help file to see if there was such a limitation.
Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg