I didn't think of that and I should have, each price is a daily price so if the price for a pitch is £9.00 on the 31/01/2010 and the price of the pitch is £9.70 for the 01/01/2011 then the total should be £18.70

And after looking at the data that has not happened.

How do we amend the code to compensate for that?

This will be a bit complexI will try and post a solution as soon as I get some time for thatMeanwhile I think somebody else might help as well..