Hour stated in Daily max query

[mohsin via AccessMonster.com]

Hi

I need to show the "time" when data was taken max daily, as an example below;

tblmaxdata
"Field A" "date" "hour" "Maxdata(from tblhourly)"

Z 1.11.2007 19:00 1000
B 31.10.2007 18:00 2000


can someone guide me, what function to use, please,

thank you
-mohsin