M
myxmaster
I am almost there, however when DEBIT is entered the calculation
subtracts double the amount. For example
Credit 500
Credit 500
Debit 500
The result will show 0 instead of $500
Here is the expression:
=DSum("Amount", "YourTable", "TransactionType = ""Credit""") -
Nz(DSum("Amount", "YourTable", "TransactionType = ""Debit"""),0)
TIA
subtracts double the amount. For example
Credit 500
Credit 500
Debit 500
The result will show 0 instead of $500
Here is the expression:
=DSum("Amount", "YourTable", "TransactionType = ""Credit""") -
Nz(DSum("Amount", "YourTable", "TransactionType = ""Debit"""),0)
TIA