Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding quantity in free table
Message
De
19/12/2006 10:04:54
 
 
À
19/12/2006 10:01:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01178051
Message ID:
01178854
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform