Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding quantity in free table
Message
From
19/12/2006 10:04:54
 
 
To
19/12/2006 10:01:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01178051
Message ID:
01178854
Views:
19
This message has been marked as a message which has helped to the initial question of the thread.
Please, run SQL separately, exactly how I wrote it, and BROWSE the result.

>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
>
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform