Sorry, we cannot move further until you will tell me if this SQL returns right data:
SELECT vendorID, ;
cnt(*) AS NumReceipts, ;
SUM(qtyrecv) AS QtyRecv, ;
SUM(qtyrej) AS QtyRej ;
FROM PoEntry ;
INTO CURSOR VndrPerf ;
group by 1
It doesn't mean that anything else Ok, but you claim that data result is wrong so you got to make sure firstly that this SQL really works for you.
Edward Pikman
Independent Consultant