>Hi Ed,
>
>Sorry about all this trouble. I am trying to create GUI that accepts startdate and enddate. With this, it will gather all info such as Vendor ID, Vendor Name, Number of Receipts, Qty Received, Qty Rejected, % Rejected, and % OnTime (which I am still trying to figure out how to do). For a particular vendor, it will add all the number of receipts, total the qty received as well as total qty rejected. A separate column will calculate the % Rejected as with our formula. The OnTime is optional.
>
>With the code that I just sent you, the number of receipts, qty received and qty rejected are doubled. Please help.
>
>Yes, I am still using VFP 6.0.
>
>Please advice.
>
>Thank you so much,
>Sam
Do you mean that running:
SELECT vendorID, ;
cnt(*) AS NumReceipts, ;
SUM(qtyrecv) AS qtyrecv, ;
SUM(qtyrej) AS qtyrej ;
Into cursor mycursor ;
Group by 1
gives you double-data in mycursor?
Btw, what's about SET DELETED setting in your application? It should be SET DELETED ON.
Edward Pikman
Independent Consultant