Recent content by mtonkins

I was, I noticed the error earlier.. Thanks for the tip, the query works well.

Ok.. Ignore me.. I was subtracting the record from itself!! It seems to work Thanks

Thanks for the response Brian, I have had a stab at it and used the following code:- SELECT SurveyData.Record, SurveyData.SurveyID, SurveyData.DateTimez, SurveyData.mN, SurveyData.mE, SurveyData.mRL, SurveyData.Record-SurveyData_1.Record AS dE FROM SurveyData INNER JOIN SurveyData AS...

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...

This is a very useful post. I have had a read of the information about sub-queries. I have one question. I too am trying to create a query that calculates the difference between a field and its previous field. I used the code from the Sub query basics tip sheet. Now, I keep running into this...