Hi Tore,

Thanks for the info. I actually just add the COMNAM_08 as GROUP BY. I am not sure what EB means. Please explain. Thanks!

I have this now and I am getting the right data.

SELECT VENID_55, COMNAM_08, SUM(ORDCST_55*TNXQTY_55) AS POCOST, ;
	SUM(COST_55*TNXQTY_55) AS STDCOST ;					
FROM VRSUMINV1 ;
GROUP BY 1,2 ;
ORDER BY 4 DESC ;
INTO CURSOR VRSUMINV2

Best Regards,
Sam