>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 >