Mileage Log

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