How to hide records if the calculated total equals zero

  • Thread starter Thread starter Deb Struble
  • Start date Start date
D

Deb Struble

I am working on a Physical Inventory Count Worksheet. The report groups by
Part Number. In the detail section I have the various locations a Part is
located at, the qty at each location from our Manufacturing Software, the
qty that was counted at each location, and the Variance (difference between
Software Qty and Count Qty). I am using a subtotal field in the Part Number
Footer to calculate the overall totals for the Variance of a Part. If the
Subtotal equals zero I would like to be able to hide the Part Number Header,
the Detail for that Part, and the Part Number Footer. Does anyone have any
suggestions on how I could go about accomplishing this? Thanks in advance!
 
You would need to create a totals query that groups by your partnumber and
calculates your total. Add this query to your report's recordsource query
and this will allow you to filter out the zeros.
 
Back
Top