Access Date and aggregation Query

[Geoff]

Hi

I have a Access database which store data from my weather station.

I am struggling to write query which will give me the maximum temperature in
the last 24 hours.

I have date/time field

Select Max(temp) from tblsimpleweather where Now() hours less than 24 hours


Thank you in anticipation

 

[Geoff]

Thanks Allen

Thanks I got close to that but got blinkered in the end.

Is it possible within MS SQL for it to give the date/time that the event
occurred?

 

[Allen Browne]

Michel Walsh has a good article on that:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm