Microsoft Access 2007 Rounding Numbers Frustration

I have a database that performs simple accounting. The problem that I am running into is that it stores many decimal places even though it is only displaying 2. This is a problem because when I add many calculated fields together, frequently the fractions of a cent stored in the database add up to a cent, and the calculation is off by a cent!

To fix this, I am using the round([fldMoney]+0.000001,2) function to round off to the nearest cent before doing the calculation and it seems to be working. If anyone has an easier suggestion let me know.

However, my real problem is this number: 480018.10

If I enter this number into a field that is set as a Single, Format Currency, 2 decimal places, it automatically changes it to 480018.09375 -- which gets rounded to 480018.09

I've tried it on several fields of my database and they all do it, so it isn't a bug on the one field, it's something to do with Access. Anyone know how to fix this?
netmergenceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lee555J5Commented:
Why do you not use the Currency data type for you money fields? That is what it is for.
Lee
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lee555J5Commented:
Correction: *your* money fields
Also, you can control your decimal places in the table definition once you select a field to use the currency data type.
Lee
0
netmergenceAuthor Commented:
Bingo! I had no idea...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.