Hello all.
I have a rather interesting problem, and I can't seem to find the right solution.
I am working with a database which contains dates and a measurement value with data within the following fields:-
Record
SurveyID
DateTimez
mX
mY
mZ
Here is an snapshot of my main table...