13/02/2019, 16:20
Kod:
SELECT TOP 7 CDate(Format([DTARIH],"Short Date")) AS Tarih, Avg(ATG_hiy.BN) AS OrtalamaBN, Avg(ATG_hiy.U) AS OrtalamaU, Avg(ATG_hiy.K) AS OrtalamaK
FROM ATG_hiy
GROUP BY CDate(Format([DTARIH],"Short Date"))
HAVING (((CDate(Format([DTARIH],"Short Date")))<=CDate([Formlar]![Form1]![f_tarih])))
ORDER BY CDate(Format([DTARIH],"Short Date")) DESC;