brunomesquita
New member
- Local time
- Today, 01:19
- Joined
- Jun 1, 2021
- Messages
- 9
Hello everyone.
I'm having problems with a balance query I started. So far, I got it working with two criteria. My problem is when I add my third one [TrainingRequestStatus]="Approved".
What is wrong with my formula?
Help, please.
I'm having problems with a balance query I started. So far, I got it working with two criteria. My problem is when I add my third one [TrainingRequestStatus]="Approved".
Code:
Balance: Val(DSum(Nz([AmountCredit],0)-Nz([AmountDebit],0),"qryTransactionsExtended","[EmployeeID]=" & [tblTransactions].[EmployeeID] & "AND [TransactionID]<=" & [TransactionID] & "AND [TrainingRequestStatus]='Approved'"))
What is wrong with my formula?
Help, please.