I've got a data table with temperature data that's being collected once an hour around the clock. The data looks like this (imagine that there are 2 columns - 1 called Date and 1 called Temperature:
...and it goes on like this for the entire year.
I want to run a query or VBA script that will give me summaries of this data. For example, how would I write a query or VBA script that will return the MAX temperature recorded in May? Ideally, this same query will work on temperature readings from other years so that if I'm working with temperatures recorded in 2003, I won't have to re-write the scripts. Is that possible? I tried doing a
SELECT MAX(Temperature) from DataTable
WHERE [Date] LIKE '5/%'
but that didn't work at all. Any ideas? Thanks a lot for your help!