>REPORT FORM CDIPIU FOR LEFT(IN_STOCK,2) <> "LP" TO PRINTER >>Now I need it NOT to print any entry with an iutotal AND in_onhand equal to 0. iutotal tracks the number used over the course of the reporting cycle and in_onhand is just the number we have in the building. If either of them has a total other than zero I need the entry to print, but if BOTH are 0 I need to exclude it from the report...
REPORT FORM CDIPIU FOR ( LEFT(in_stock,2)<>"LP" ) AND ( NOT(iutotal>0 AND in_onhand=0) ) TO PRINTERI find parentheses help me read an expression even when the compiler does not need them.