I'm continue to struggle with this problem. My report prints records which include Date, CustomerName and three category fields and a three fields showing the quantity of units in each in the three categories.
Date, [CustomerName], [Item1], [Item1QTY], [Item2], [Item2QTY], [Item3], [Item3QTY]
I want to build a report which excludes all records from the report where if all 3 Quantity fields are Zero/Null.
The report works well - except that I get a whole series of zero records.
I'm trying to use the Query builder in Access2010 and I can make it exclude the record if just one of the categories is Null by using "<>0" in the Criteria line/box on the Query builder, but of course this means that records which have values other QTY fields are also excluded if [ItemQTY1] is zero. Neither can I put "<>0" in the Criteria box of all three fields in the query.
I've tried building an expression in a column of the query builder but I can't get that to work.
Can anyone help?
The problem is in 2 parts:
1. What is the right syntax for the expression I need to use and
2. Where do I put it.
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.
=Jimbo=