I have data which has the following fields:
Date
Time
Variable
--------
Time goes down to milliseconds
I wish to group all records where the time is in a 30 minute interval and output 1 record which averages the variable values.
Is it possible to do this with a query ?
(it is like the grouping available in excel when producing a pivot table)