D
drt
Pls. advise
drt
Sends
drt
Sends
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave
That's a pretty general question; I think the answer may be, "Hire a
consultant"
consultant"
J
John Vinson
Pls. advise
drt
Sends
Create a table which contains the maintenance information, and use
Totals queries to get monthly and yearly summaries.
For a more detailed answer... please post a more detailed question,
preferably in the bodyof the message rather than in the Subject line.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
J
John Parkinson
drt,
This is something we have had in place for several years.
Set up two tables, vehicle and maint
vehicle table
vehno
vehmake
vehmodel
vehserial
vehcost
etc
maint table
vehno
maint_date
maint_part
maint_part_no
maint_part_cost
etc
the relationship between the two tables is the vehno. We have always used
the vehicle year and the order the vehicles were purchased, example: 200401 =
first vehicle bought in 2004, 199710 = 10th vehicle bought in 1997.
Then you can set up queries to track vehicle cost by month date etc.
For what it is worth we also have a fuel table to track fuel use by vehicle.
John
This is something we have had in place for several years.
Set up two tables, vehicle and maint
vehicle table
vehno
vehmake
vehmodel
vehserial
vehcost
etc
maint table
vehno
maint_date
maint_part
maint_part_no
maint_part_cost
etc
the relationship between the two tables is the vehno. We have always used
the vehicle year and the order the vehicles were purchased, example: 200401 =
first vehicle bought in 2004, 199710 = 10th vehicle bought in 1997.
Then you can set up queries to track vehicle cost by month date etc.
For what it is worth we also have a fuel table to track fuel use by vehicle.
John