Alttaki sorguyu dener misiniz?
Kod:
SELECT a.hesap, a.Tarih as max_tarih,
(select max(tutar) from [ORNEK TABLO] where hesap=a.hesap and tarih=a.tarih) as normal_tutar,
(select max(tutar) from [ORNEK TABLO] where hesap=a.hesap ) AS max_tutar, (select min(tutar) from [ORNEK TABLO] where hesap=a.hesap) AS min_tutar
FROM [ORNEK TABLO] AS a
WHERE (((a.Tarih) In (select max(tarih) from [ORNEK TABLO] where hesap=a.hesap )))
GROUP BY a.hesap, a.Tarih