Totals rounding up or down.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

drafter

Thread Starter
Joined
Nov 21, 2000
Messages
419
I have built myself a database with access2000 and all my calculations seem to work right until I turn them in to currency format (2 decimal places) then sometimes my totals are 1 cent more than they should be. I'm sure this is due to either rounding up or rounding down. Can any body tell me how to get true totals.

thanx
 

DaveBurnett

Account Closed
Joined
Nov 11, 2002
Messages
12,970
You need to round before you total (in this case). Generally it is not a good idea, but in order to get the total to be the sum of the displayed figures you have to do it.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top