Show only balances due

[KatieK]

I have a report that provides extensive detail. I want to limit this report to show only those customers with Balances Due.

Balance Due = 0, do not show on report.

Do I have to create another query based on this? Or can I somehow modify the current query which has a calculation in it to show only those records with Balance Due?

The current calculation is this: Balance Due: [Film Rental]-[Paid]

 

[RichO]

Simple, below the balance due field in the criteria box, enter

>0

 

[neileg]

If it is possible that there might be a negative balance (ie an overpayment), use <>0 otherwise your report will only show positive balances.