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.