Software

Ask something
Discussion Locked

Don't list zero balance in report

0 helpful
4 replies

by connellg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

4 replies

by dklippert

Look up the NZ function. Also look at Formatting the field.
Access uses this pattern
Positive,Negative,Zero

by dklippert

Go to the field in the report and open up the Properties box (right click choose Properties).
On the format tab enter something like:

+0.0;-0.0;""

Semicolons are the seperation signs.

by connellg

I tried your suggestion. The result was the 0 quantity was changed to null. What is needed is for that detail line not to print at all. For example the detail line (among dozens of detail lines)in question looks like this:

Lot Orig QtySold Available
101 500 500 0

Customer has asked that when the "Available" calculates to zero, as in the above example, the entire line does not appear in the report.

Thanks for your help.

This discussion is closed to new replies.