Another opinion or ideas, Please

[Guest]

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?

 

[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.

 

[Guest]

Thank you for your reply.

Do think this is also best for tracking 400+ vehicles?

 

[Douglas J. Steele]

Yes.