GinaStar
New member
- Local time
- Today, 17:27
- Joined
- Nov 18, 2021
- Messages
- 5
I need some advice please? I'm currently setting up a new maintenance database for the office - currently we use an excel spreadsheet to track grease/oil, etc - it's laid out like this:
truck Blank OilDate Miles due Current TransDate Miles Due OverDat Miles Due Svc ACF Blower BlowerO BDate TruckWash
5602 06/21/21 781839 9704 789635 12/10/20 764416 224781 12/10/20 764416 224781 781839 06/21/21 113 113 07/05/21 07/29/21
The blank field is a field the mechanic uses when he works on the truck - he puts the date/miles in when he does the servicing. there is a small column next to each section that he can mark if it is the oil, transmission, overhead, air/cab/fuel filter replaced, or blower/blower oil, or truck washed. The "Current" field is updated weekly from the drivers logs from the past week. the "due" field is a simpe "current"-"miles" with a conditional format behind it - when it gets down to 500 (close to being time to be serviced) - it turns a light pink, when it gets down to 0 (due and/or past due), it turns to dark pink).
I've attached a copy of the excel spreadsheet if anyone wants to see how I've got it set up - I've used it for about 15 years - my mechanics love it.
What I want to do is convert this over to Access. I already have the forms set up. I key the maintentance part in as follows:
Grease table: Mileage Table: Vehicle Table:
GreaseOilID MileageID TruckID
TruckID TruckID Company
Date WDate Truck #
Mileage WMileage Unit Type
Type
Loads
They link on Truck ID
The final report will be sorted by Company then by Unit type then by truck #
We have 2 companies, and several unit types.
Anyone have any suggestions as to how I can lay this out? I've been working on it a few days.
truck Blank OilDate Miles due Current TransDate Miles Due OverDat Miles Due Svc ACF Blower BlowerO BDate TruckWash
5602 06/21/21 781839 9704 789635 12/10/20 764416 224781 12/10/20 764416 224781 781839 06/21/21 113 113 07/05/21 07/29/21
The blank field is a field the mechanic uses when he works on the truck - he puts the date/miles in when he does the servicing. there is a small column next to each section that he can mark if it is the oil, transmission, overhead, air/cab/fuel filter replaced, or blower/blower oil, or truck washed. The "Current" field is updated weekly from the drivers logs from the past week. the "due" field is a simpe "current"-"miles" with a conditional format behind it - when it gets down to 500 (close to being time to be serviced) - it turns a light pink, when it gets down to 0 (due and/or past due), it turns to dark pink).
I've attached a copy of the excel spreadsheet if anyone wants to see how I've got it set up - I've used it for about 15 years - my mechanics love it.
What I want to do is convert this over to Access. I already have the forms set up. I key the maintentance part in as follows:
Grease table: Mileage Table: Vehicle Table:
GreaseOilID MileageID TruckID
TruckID TruckID Company
Date WDate Truck #
Mileage WMileage Unit Type
Type
Loads
They link on Truck ID
The final report will be sorted by Company then by Unit type then by truck #
We have 2 companies, and several unit types.
Anyone have any suggestions as to how I can lay this out? I've been working on it a few days.