Access Date and aggregation Query

  • Thread starter Thread starter Geoff
  • Start date Start date
G

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
 
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?
 
Back
Top