SELECT vendorID, ; vendorname AS VenName, ; cnt(*) AS NumReceipts, ; SUM(qtyrecv) AS QtyRecv, ; SUM(qtyrej) AS QtyRej, ; ROUND(QtyRej/QtyRecv*100,2) as PerRej ; FROM PoEntry GROUP BY 1 ; WHERE daterecv BETWEEN StartDate AND EndDate ; INTO CURSOR VndrPerf