I have a database that I use to track odometre readings. Several
vehicles are tracked. As you can imagine, if the wrong vehicle is
entered for the given mileage, it will through off reporting. I would
like to include some kind of validation or error checking.
1) Display or check against the last entered record for the vehicle
(by DATE).
2) Then doesn't allow the new entry to be less than the last one or
500 km more than the last one.
I'm by no means an expert with Access.
Magic