Another opinion or ideas, Please

H

Helga

I need to track mileage on a vehicle for a minimum 2.5 to 3 year period at a
time. I also need to be able to report on a monthly basis such things as
missing mileage and/or total mileage between any given months. I have
created a table that includes 3 fields to specify the year and for each year
12 mileage fields (1 for each month). I am not positive this is the best way
to go about this. Any ideas?
 
D

Douglas J. Steele

No, it's not the best way.

Better would be to three fields: Year, Month and Mileage for the month.
You'll have 12 rows in the table, rather than 1 row with 12 mileage fields
for each year.
 
Top