>>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! ;-)

I'm glad that my post wasn't in vain. :)