Access; Calculating Not good

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access to keep a ledger of my financial dealings. The Bank also
keeps up with my accounts payable. Access figures does not keep up with the
Banks calculation. I have checked the banks figures and they are correct,
however Access will loose some of the values in its calculation. To put it
simply, the balance in access does not match the balance that the bank Shows.
Is there a patch for access that could correct this???
 
I am using Access to keep a ledger of my financial dealings. The Bank also
keeps up with my accounts payable. Access figures does not keep up with the
Banks calculation. I have checked the banks figures and they are correct,
however Access will loose some of the values in its calculation. To put it
simply, the balance in access does not match the balance that the bank Shows.
Is there a patch for access that could correct this???
Click to expand...

Without seeing your database, or what you mean by 'lose some values'
it is hard to tell.
I would suspect, assuming you are correctly calculating your balances,
that you are using an incorrect datatype. Make sure you are using
Currency datatype to avoid rounding errors.
Also, when summing, use the Nz() function to avoid Null errors.
 
Back
Top