Punkoff,
c'est ok , j'ai pu traduire le code sql en access
HAVING (((dbo_vwInductionGrp1Samples.TimeStamp) Between Minute(Now())-15 And Minute(Now())))
la requete complète est donc la suivante
1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT
dbo_vwInductionGrp1Samples.TimeStamp,
dbo_vwInductionGrp1Samples.Induction1,
dbo_vwInductionGrp1Samples.Induction2,
dbo_vwInductionGrp1Samples.Induction3,
dbo_vwInductionGrp1Samples.Induction4,
dbo_vwInductionGrp1Samples.Induction5
FROM dbo_vwInductionGrp1Samples
GROUP BY dbo_vwInductionGrp1Samples.TimeStamp, dbo_vwInductionGrp1Samples.Induction1, dbo_vwInductionGrp1Samples.Induction2, dbo_vwInductionGrp1Samples.Induction3, dbo_vwInductionGrp1Samples.Induction4, dbo_vwInductionGrp1Samples.Induction5
HAVING (((dbo_vwInductionGrp1Samples.TimeStamp) Between Minute(Now())-15 And Minute(Now())));[/ |
Merci pour ton aide
Partager