Please, explain what exactly is wrong. Also, you don't need in SCAN, you get cursor by SQL, right away.
Btw, do you use VFP6?

>Hi Ed,
>
>I have put in the code that you gave me as shown below and somehow I am not getting the right data in my report. I have added the "INTO CURSOR PoOrders" as well. Please advice.
>
>
>

>* Create VendorPerformance cursor to hold the report...
>CREATE CURSOR VndrPerf(VendorID C(5), VenName C(25), NumReceipts I, QtyRecv N(10), ;
>		QtyRej N(6), PerRej B(2), OnTime B(2))
>		
>SELECT vendorID, vendorname, ;
>	cnt(*) AS NumReceipts, ;
>	SUM(qtyrecv) AS qtyrecv, ;
>	SUM(qtyrej) AS qtyrej, ;
>	ROUND(100*SUM(qtyrej)/SUM(qtyrecv),2) AS PerRej ;
>FROM PoEntry GROUP BY 1 ;
>INTO CURSOR PoOrders
>	
>Scan
>  INSERT INTO VndrPerf(VendorID, VenName, NumReceipts, QtyRecv, QtyRej, PerRej, OnTime) ;
>  VALUES (PoOrders.VendorID, PoOrders.VendorName, PoOrders.NumReceipts, PoOrders.QtyRecv, ;
>	PoOrders.QtyRej, PoOrders.PerRej,0)
>EndScan
>

>
>

>Select vendorid,vendorname,cnt() as vendorcnt,sum(qtyrecv) as qtyrecv, ;
>sum(qtyrej) as qtyrej,round(100*sum(qtyrej)/sum(qtyrecv),2) as perrej ;
>from rejects group by 1
>