>Try (VFP9 only)

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
>

>
Sergey, you are amazing! I was just getting ready to send a message saying you're previous answer worked from the command window but didn't work from within a form method when I saw your second approach. Tried it and it works. So, you're getting so fast that you answer my questions before I ask them! ;-)

Thanks again,