1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| SELECT tblstintdata.refstint,
tblstintdata.s1,
tblstintdata.s2,
tblstintdata.s3,
tblstintdata.laptime,
tblstintdata.[c60/sc/rf/ol/il],
Min(tblstintdata.s1) AS MinS1,
Min(tblstintdata.s2) AS MinS2,
Min(tblstintdata.s3) AS MinS3,
Min(tblstintdata.laptime) AS MinLaptime,
Avg(tblstintdata.s1) AS MoyS1,
Avg(tblstintdata.s2) AS MoyS2,
Avg(tblstintdata.s3) AS MoyS3,
Avg(tblstintdata.laptime) AS MoyLaptime,
Max(tblstintdata.s1) AS MaxS1,
Max(tblstintdata.s2) AS MaxS2,
Max(tblstintdata.s3) AS MaxS3,
Max(tblstintdata.laptime) AS MaxLaptime
FROM tblstint
INNER JOIN tblstintdata
ON tblstint.refstint = tblstintdata.refstint
GROUP BY tblstintdata.refstint,
tblstintdata.s1,
tblstintdata.s2,
tblstintdata.s3,
tblstintdata.laptime,
tblstintdata.[c60/sc/rf/ol/il]
HAVING
( ( ( tblstintdata.refstint ) = [Formulaires].[frmstint].[refstint] )
AND ( ( tblstintdata.[c60/sc/rf/ol/il] ) = Isnull([c60/sc/rf/ol/il]) ) ); |
Partager