Access Date and aggregation Query

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
 
G

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top