1 2 3 4
| SELECT DISTINCT Commande.NumCommande, Commande.diametre, Commande.TypeDeFiletage, Commande.grade, OperationCasing.Poste, OperationCasing.DateSaisie, Sum(OperationCasing.TempsPresence) AS temps, Sum(OperationCasing.BoutsBons) AS Bons
FROM OperationCasing, Commande
WHERE (((Commande.NumCommande)=[OperationCasing].[NumCommande]) AND ((OperationCasing.NomPoste)='HT4822' Or (OperationCasing.NomPoste)='HT4821' Or (OperationCasing.NomPoste)='ST4421' Or (OperationCasing.NomPoste)='ST4420') AND ((OperationCasing.DateSaisie)=#10/24/2005#))
GROUP BY Commande.NumCommande, Commande.diametre, Commande.TypeDeFiletage, Commande.grade, OperationCasing.Poste, OperationCasing.DateSaisie; |