How do I establish a vehicle maintenance record monthly and yearl.

[Guest]

Pls. advise

drt
Sends

 

[Dave]

That's a pretty general question; I think the answer may be, "Hire a
consultant"

 

[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

 

[Guest]

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