Hi All,
My report prints records which include Date, CustomerName and three category fields - each with a field showing the quantity of each of the three categories.
Date CustomerName Item1 Item1QTY Item 2 Item2QTY Item3 Item3QTY
I want to exclude from the report any customers where all Three category Quantities are Null.
I can make it exclude the record if one of the categories is Null by using "<>0" in the Criteria field on the Query builder, but of course this means that records which have values in Item 2 & 3 categories are also excluded. I don't know how to build the expression which looks at all three fields before excluding the record...
Basically, I need the record to be excluded from the report if "Item1Qty" AND "Item2Qty" AND "Item3Qty" are ALL Null.
I've tried building a Query that does this job, but it's beyond me.
Can anyone help?
=Jimbo=