Kod:
SELECT top 7 CDate([DTARIH]) 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([DTARIH])
HAVING (((CDate([DTARIH]))<=DateAdd("d",-7,CDate([Formlar]![Form1]![f_tarih]))))
ORDER BY CDate([DTARIH]) DESC;