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

Click here to load this message in the networking platform