Hello,
I need to create a mileage log from a weekly schedule that I have on a table on the database. what I need is a script to calculate the mileage between two addresses with some conditions.
this is the data for an example
date / client / address / miles / is id
2/15/13 name address 0.00 10
2/15/13 name address calculate 10
2/15/13 name address calculate 10
2/15/13 name address calculate 10
2/15/13 name address calculate 10
2/16/13 name address 0.00 10
2/16/13 name address calculate 10
if it is the first client in the day the start miles are 0 and then the calculation needs to be done starting from there