I have data from a weather station that reports a record about every twenty seconds or so. The data-set has separate fields for formatted for date and time. I’d like to run a query that lists all the records that occur when the minutes of each record equal ‘00’ (top of the hour). What I want to end up with is about three records at the top of each hour from which I can pick one value.
What criteria would I enter to have the query spit out records where the minutes in the time field equal ‘00’?