Help with Expression to ignore $0.00

micko1

Registered User.
Local time
Today, 23:48
Joined
Jun 11, 2011
Messages
16
Hoping someone can help. I have a query with the following expression.
Problem is if the amount ends up Zero Dollars it still shows it as an entry. How can I exclude Zero Dollar entries.
Any help would be greatly appreciated.


Expected Payments: IIf(IsNull([actualpaymentamount]),[paymentamount],[paymentamount]-[actualpaymentamount])
 
Use <>0 in the criteria row under the above expression column to filter the non-zero entries (+ -) alone.
 
Thank you very much for your help. Something so simple when you know how. Thanks again.
 

Users who are viewing this thread

Back
Top Bottom