Delete accounts with a total of zero from report

[Denlkap]

I have asked this question before a while ago but I can't find the responses so please forgive me for asking it again.



I have a database with individual accounts for people. The report I presently have shows, for each account, how much a person ordered and how much they owe on the orders. The report also shows how much they have paid and a balance due (or overpayment if they have paid too much. The report contains formulas that adds up orders and payments, subtracts the payments from the orders and shows a balance.

Right now when I run the report, I get all accounts. I do not want to show accounts that are zero. I only want to show accounts that have a positive or negative balance.

I'm at a loss. Any help would be greatly appreciated.

[pbaldy]

If the calculations can be moved to the query underlying the report, the query or report can be filtered on the final result:

<>0