I need help creating a calculated expression in a report to give me a total.
Here is what my table looks like:
Type Amount
Charge 500
Credit 250
Debit 10
Payment 260
Essentially, this is the formula: Charge-Credit+Debit-Payment. But it’s not that easy in Access; I believe I need some iif logic here, right? Something like if Type=Credit, then – (Amount), etc. ???