Thanks all for the very quick replies.
To add some more to my question, I’ll try to give a simplistic example.
I have four fields in the same table; Date, Number, Miles & Yes/No
The date field is self explanatory, the Number field is a series say from 1 to 10, Miles is the amount of miles...