Search results
-
J
data type mismatch in criteria expression
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. -
J
data type mismatch in criteria expression
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... -
J
Summing Records in a Query
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...