Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding quantity in free table
Message
From
19/12/2006 10:01:46
 
 
To
19/12/2006 09:57:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01178051
Message ID:
01178852
Views:
10
Hi Ed,

Yes, I have used that SQL string that you gave me and the data is still doubling.

Thanks,
Sam
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform