Null values displayed

[chunyih]

In my inventory report, i made a field called Balance.
It shows the remaining units from a query ( SumOfUnitsReceived - SumOfUnitsSold)
It shows them even if Balance is zero.

The most I could do was to tweak the query such that UnitsReceived criteria >0.

I need something like : Only show entry in report IF Received - Sold > 0
because the report has a lot of wasted space. Any ideas?
Thanks

 

[chunyih]

Null Values

thanks, problem solved..

Under query i created a field Balance: Sum([UnitsReceived]-[UnitsSold])
and set Total to Expression.
Using the new Balance, I can now set its criteria to anything. woohoo!