distance calculation

Discussion created by leilahb on Feb 10, 2011
Latest reply on Feb 14, 2011 by leilahb

I am trying to calculate distance between two locations on a road network. However, all locations are stored in a table in order. I mean that record 1 stores the information of location 1, record 2 for location 2, ???., record n for location n. now I am trying to calculate the distance of location 1 and 2, location 2 and 3, ??? location n-1 and n. when the table has only 2 records is easy to do using a new route function (an optimal route with 2 stops)! But I don???t know how to introduce the table as (n-1) road each having 2 stops. Could you please help me in this regard? 

Thank you!