Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS [No
emp], T_production.employe AS Nom, T_production.date, T_production.nbr_hre
AS AH01, Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01,
5 AS FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS
vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3, "065"
AS Niv4, 65 AS Projet, "" AS [Note]
FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN
(T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON
T_produits.produit = T_production.type_epice) ON T_employes.employe =
T_production.employe) ON var_periode.periode = T_dates.periode
GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye],
T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5, "",
"", "", "01", 30, "065", 65;
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS [No emp], T_production.employe AS Nom, T_production.date, T_production.nbr_hre AS AH01, Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3, "065" AS Niv4, 65 AS Projet, "" AS [Note] FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN (T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON T_produits.produit = T_production.type_epice) ON T_employes.employe = T_production.employe) ON var_periode.periode = T_dates.periode GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye], T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5, "", "", "", "01", 30, "065", 65;
"Macgiver" <baboin@yahoo.ca> a écrit dans le message de
news:OoSCUUMyJHA.140@TK2MSFTNGP03.phx.gbl...
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS
[No emp], T_production.employe AS Nom, T_production.date,
T_production.nbr_hre AS AH01,
Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS
FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS
vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3,
"065" AS Niv4, 65 AS Projet, "" AS [Note]
FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN
(T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON
T_produits.produit = T_production.type_epice) ON T_employes.employe =
T_production.employe) ON var_periode.periode = T_dates.periode
GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye],
T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5,
"", "", "", "01", 30, "065", 65;
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS [No emp], T_production.employe AS Nom, T_production.date, T_production.nbr_hre AS AH01, Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3, "065" AS Niv4, 65 AS Projet, "" AS [Note] FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN (T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON T_produits.produit = T_production.type_epice) ON T_employes.employe = T_production.employe) ON var_periode.periode = T_dates.periode GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye], T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5, "", "", "", "01", 30, "065", 65;
est-il possible?
merci
Thierry
Je le remets car le copier/coller n'a pas fonctionné parfaitement :
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS [No emp], T_production.employe AS Nom, T_production.date, T_production.nbr_hre AS AH01, Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3, "065" AS Niv4, 65 AS Projet, "" AS [Note] FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN (T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON T_produits.produit = T_production.type_epice) ON T_employes.employe = T_production.employe) ON var_periode.periode = T_dates.periode GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye], T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5, "", "", "", "01", 30, "065", 65;
est-il possible?
merci
Je le remets car le copier/coller n'a pas fonctionné parfaitement :
"Macgiver" <baboin@yahoo.ca> a écrit dans le message de
news:OoSCUUMyJHA.140@TK2MSFTNGP03.phx.gbl...
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS
[No emp], T_production.employe AS Nom, T_production.date,
T_production.nbr_hre AS AH01,
Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS
FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS
vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3,
"065" AS Niv4, 65 AS Projet, "" AS [Note]
FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN
(T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON
T_produits.produit = T_production.type_epice) ON T_employes.employe =
T_production.employe) ON var_periode.periode = T_dates.periode
GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye],
T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5,
"", "", "", "01", 30, "065", 65;
Bonjour a tous je voudrais transformer cette requete SQL en VBA :
SELECT [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye] AS [No emp], T_production.employe AS Nom, T_production.date, T_production.nbr_hre AS AH01, Sum([T_production]![poids]*[T_produits]![taux_sans_camp]) AS AM01, 5 AS FM14, 5 AS FM15, 5 AS FM16, "" AS DM19, "" AS vide1, "" AS vide2, "" AS vide3, "" AS vide4, "" AS vide5, "01" AS Niv1, "" AS Niv2, 30 AS Niv3, "065" AS Niv4, 65 AS Projet, "" AS [Note] FROM var_periode INNER JOIN (T_employes INNER JOIN (T_produits INNER JOIN (T_production INNER JOIN T_dates ON T_production.date = T_dates.date) ON T_produits.produit = T_production.type_epice) ON T_employes.employe = T_production.employe) ON var_periode.periode = T_dates.periode GROUP BY [T_employes]![groupeemploye] & "-" & [T_employes]![noemploye], T_production.employe, T_production.date, T_production.nbr_hre, 5, 5, 5, "", "", "", "01", 30, "065", 65;
