The query below returns a number of records that have a value of zero. How do I exclude those records?
Code:
SELECT Len([MasterList_tbl]![AdditionalFig])-Len(Replace([MasterList_tbl]![AdditionalFig],",","")) AS Fig, MasterList_tbl.MasterNum, Len([MasterList_tbl]![AdditionalItem])-Len(Replace([MasterList_tbl]![AdditionalItem],",","")) AS Item, MasterList_tbl.AdditionalFig, MasterList_tbl.AdditionalItem, Len([MasterList_tbl]![AdditionalFig])-Len(Replace([MasterList_tbl]![AdditionalFig],",",""))-(Len([MasterList_tbl]![AdditionalItem])-Len(Replace([MasterList_tbl]![AdditionalItem],",",""))) AS Diff
FROM MasterList_tbl
WHERE (((MasterList_tbl.AdditionalFig)<>"IsNull"));