Good day everyone
I have tried to do the following, and if any can help give guidance it would really be appreciated:
I have a Form where I input details of a vehicle test by date.
e.g.
01 July 2007 , Route 1 , 50km
02 July 2007 , Route 1 , 50km
where the date and distances are in individual text boxes in a third box I have the total distance added = 100km's.
However, sometimes a vehicle will do two different routes on the same day
e.g.
03 July 2007, Route 1 , 50km
03 July 2007, Route 2 , 75km
Now total distance = 225km's
But, in a fourth text box I would like to have the distance covered for the day
e.g. 03 July 2007, Route 1 + Route 2 = 125km's.
It is this final step that I cannot get right. How do I add the two distances based on the same date?
Thanks for your help.
Howard