P
Pip'n
I'm creating a maintenance scheduler for a fleet of trucks. I'd like to
create a form that shows the current status of the 3 maintenance items that
are to be performed for each truck. As maintenance is performed entries are
made to a Maintenance table where the unit, and Maintenance item are chosen,
and the current Mileage and Date are entered. I'd like to display date and
mileage of the last entry (greatest Mileage or date) for each Maintenance
item and show how many miles until the next scheduled maintenance is due.
How am I to do this??
Any help would be greatly appreciated,
Thanks in Advance
create a form that shows the current status of the 3 maintenance items that
are to be performed for each truck. As maintenance is performed entries are
made to a Maintenance table where the unit, and Maintenance item are chosen,
and the current Mileage and Date are entered. I'd like to display date and
mileage of the last entry (greatest Mileage or date) for each Maintenance
item and show how many miles until the next scheduled maintenance is due.
How am I to do this??
Any help would be greatly appreciated,
Thanks in Advance