General discussion
August 20, 2002 at 03:50 AM
connellg

Don’t list zero balance in report

by connellg . Updated 24 years, 1 month ago

In Access 2000 I have a report showing an available balance based on OriginalQty-Orders+Returns. The underlying query contains queries which have calculated the totals for each component (Original, Orders, Returns). It all calculates correctly. The customer now requires that if the expression yields a balance of zero, the entire detail line item does not show on the report. Is there a way to achieve this?

This discussion is locked

All Comments