Best Picks (92)k=1, st= Sales Type select count(distinct ItemNo) as NumberItems, CB6_NewItem from inventory where Mfg = 'SICCE' and Mfg = 'SICCE' and CB6_NewItem not like '' group by CB6_NewItem order by CB6_NewItem
New (6)k=2, st= Sales Type select count(distinct ItemNo) as NumberItems, CB5_OnSale from inventory where Mfg = 'SICCE' and Mfg = 'SICCE' and CB5_OnSale not like '' group by CB5_OnSale order by CB5_OnSale
On Sale (160)k=3, st= Sales Type select count(distinct ItemNo) as NumberItems, CB8_ClearanceItem from inventory where Mfg = 'SICCE' and Mfg = 'SICCE' and CB8_ClearanceItem not like '' group by CB8_ClearanceItem order by CB8_ClearanceItem
k=4, st=
Additives* (12)Controllers & Monitors (1)Filter & Reactor Media* (39)Filtration* (38)Foods & Feeding* (2)Heating & Cooling* (8)Lighting* (1)Medications,Prevention, & Pests* (2)Pumps & Flow* (119)Water Conditioners, R/O, & Salt* (1)Replacement Parts (321)
Jack q=select count(distinct ItemNo) as NumberItems, Type from inventory where Mfg = 'SICCE' and Mfg = 'SICCE' group by Type order by Type, nr=8 (75)Fresh & Saltwater (133)Freshwater (5)Freshwater & Saltwater (4)N/A (221)Pond (19)Pond, Fresh & Saltwater (50)Saltwater (37)