Wow That was a quick reply!!
That makes sense, They would be permanent records - so the key thing here is to have the table in date order, so the loop moves forward and collects data in correct order?
I obviously need to do this for every horse seperately, so this will need to be specified in...