How do I calcualte the date diffrence between a list of records

D

Dax

I have a table in Access 2003 that has the Data from some GPS units. I want
to be able to extrapolate speed from this data. So I need to know is there a
way to calculate the difference between the data in records? (As I have
15810580 Records I am unable to do this in Excell)

For example I have the following data

vehicle_id vehicle_position_date_time loc_x loc_y
247 12/6/2005 12:00:51 AM -115.176132 36.086185
247 12/6/2005 12:02:19 AM -115.180099 36.100403
247 12/6/2005 12:03:48 AM -115.18013 36.100319
247 12/6/2005 12:05:17 AM -115.183067 36.100925
247 12/6/2005 12:06:47 AM -115.183533 36.105957
247 12/6/2005 12:07:48 AM -115.18367 36.106812
247 12/6/2005 12:08:17 AM -115.183632 36.106781
247 12/6/2005 12:09:46 AM -115.18367 36.106754
247 12/6/2005 12:12:43 AM -115.183563 36.106781
247 12/6/2005 12:14:12 AM -115.183632 36.106812
247 12/6/2005 12:15:41 AM -115.183601 36.106781
247 12/6/2005 12:17:10 AM -115.183563 36.106781
247 12/6/2005 12:18:39 AM -115.183632 36.106812


And I want to be able to calculate the difference in time and in X & Y from
the Following record, and put those values in fields in the records.
Example for the first record date difference = 2 min 10 Seconds, X
Difference = 0.003967, Y difference = 0.014218 and be able to populate a
field in record 1 with those answers. And be able to do that for all of the
records.

Any help would be appreciated.

-Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top