Still getting same error :( All these fields are set to currency as well.
I tried making CurrentBalance a Calculated field instead and now it says that the field is not updatable.
I have an update query for tGLCashAccount where it adds a value from another table with the BeginningBalance to arrive at CurrentBalance.
Here's what it looks like in design view:
Field: CurrentBalance
Table: tGLCashAcct
Update to...
So I have a query which displays sales and cash deposits for the day. I want a sum of all cash deposits.
So it looks like this..
Date________________Amount_______________SumOfAmount____________Exp1
17/7/2013___________$55___________________$55____________________$55...