M
myxmaster
I have the following in a unbound text box.
=DSum("[Amount]", "YourTable", "[TransactionType] = ""Credit""") -
DSum("[Amount]", "YourTable", "[Status] = ""Cleared""")
This works however not until I put cleared in the status in the field.
If I have 10 credit transactions nothing will show however as soon as
I enter 1 cleared it will show that transaction. What I need to do is
show all the transactions however if cleared is entered then it will
remove that total from the sum.
TIA
=DSum("[Amount]", "YourTable", "[TransactionType] = ""Credit""") -
DSum("[Amount]", "YourTable", "[Status] = ""Cleared""")
This works however not until I put cleared in the status in the field.
If I have 10 credit transactions nothing will show however as soon as
I enter 1 cleared it will show that transaction. What I need to do is
show all the transactions however if cleared is entered then it will
remove that total from the sum.
TIA