SELECT RoseBran.ItemNo, ; RoseBran.Descrip, ; RoseBran.Descrip1, ; SUM(ARST.Shipped) as Shipped ; FROM RoseBran ; LEFT OUTER JOIN ( SELECT SUM(Shipped) AS Shipped, ItemNo FROM ARSTrans WHERE BETWEEN(DateShip, DATE(2005,01,01), DATE()); GROUP BY 2) ARST ; ON RoseBran.ItemNo = ARST.ItemNo ; GROUP BY 1, 2, 3 ; ORDER BY 1 ; INTO CURSOR TEMP>>Try to change WHERE clause to
WHERE BETWEEN(ARSTrans.DateShip,CTOD('2005/01/01'),DATE()) OR ARSTrans.DateShip IS NULL) ;>>