Extracting data based on time

[MAY]

I have a data logger that collects data every 5 seconds from 2 sources. I
have imported the data into 2 tables. How can I extract data every 5 minutes
at the hh:mm:00 time value (i.e. at 0 seconds) – so that I can perform
calculations on the extracted data for the same time values

 

[Allen Browne]

To select all the records where the data was added within the last 5
minutes, create a query and type an expression like this into the Field row
under the date/time field that records the date and time the record was
added:

 

[pietlinden]

I have a data logger that collects data every 5 seconds from 2 sources. I
have imported the data into 2 tables. How can I extract data every 5 minutes
at the hh:mm:00 time value (i.e. at 0 seconds) – so that I can perform
calculations on the extracted data for the same time values

Use a form with a Timer event and execute your code in the OnTimer
event.

Private Sub Form_Timer()
DBEngine(0)(0).Execute "SomeAppendQuery", dbFailOnError
End Sub

You need to set the form's TimerInterval to some number of
milliseconds.

I guess you could write something so that the timer event runs at some
exact time...