OK I have changed the query to this...
Total: DSum("[PayeeAmt]","TBL_Balance","DDRDate]<=" & [DDRDate])
Where PayeeAmt is my figure, TBL_Balance is my table and DDRDate is the date field within the table.
But it shows '#Error?'
OK I have changed the query to this...
Total: DSum("[PayeeAmt]","TBL_Balance","DDRDate]<=" & [DDRDate])
Where PayeeAmt is my figure, TBL_Balance is my table and DDRDate is the date field within the table.
But it shows '#Error?'
Posting Permissions
Reply With Quote