Printing zero values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields in a query [unitsin] [unitsout] for a particular inventory location. The calculation for available units for that location is done in the report. Currently it prints a product with an inventory amount of zero. I need it to not show or print this item if this value is zero. I guess it needs to skip to the next detail. Any info would be greatly appreciated
 
You could use an IIF like:
=IIF([unitsin]-[unitsout]=0,"",[unitsin]-[unitsout])
This would place a blank if the result is 0.
Hope this helps.
Fons
-----Original Message-----
I have two fields in a query [unitsin] [unitsout] for a
Click to expand...
particular inventory location. The calculation for
available units for that location is done in the report.
Currently it prints a product with an inventory amount of
zero. I need it to not show or print this item if this
value is zero. I guess it needs to skip to the next
detail. Any info would be greatly appreciated.
 
Back
Top