Situation:
SET with files - daily, vehicle, driver and fuel. FILES in question - daily and fuel. These 2 files are joined on the vehicle number field. Both contain date fields.
NEED TO DO - The daily file records fuel data on a fillup basis which is not necessarily a daily basis (it could be more than once per day, or, every other day, etc. The fuel file contains fields for date, odometer reading, gallons purchased and purchase cost. I need to be able to have the program place the the PREVIOUS fuel:odometer reading into daily:prev_odo field with the record pointer set to the same vehicle number for the current daily record (new record being created). The prev_odo field would have to be a creation field and not change if you edited the field later. This data would allow the calculation of MPG among other things and would relieve the driver of having to accurately remember the previous odometer reading for perhaps days. The drivers also change vehicles frequently, creating additional problem.
Drivers report on their daily/vehicle activity on a daily basis, because of internal accuracy and volumn problems
Any good way to do this in 3.04 without a ton of xbasic which might create on-site maintenance problems for me? They are about 35 miles from me and not at all computer literate.
Thank You
Ron Cottrell
SET with files - daily, vehicle, driver and fuel. FILES in question - daily and fuel. These 2 files are joined on the vehicle number field. Both contain date fields.
NEED TO DO - The daily file records fuel data on a fillup basis which is not necessarily a daily basis (it could be more than once per day, or, every other day, etc. The fuel file contains fields for date, odometer reading, gallons purchased and purchase cost. I need to be able to have the program place the the PREVIOUS fuel:odometer reading into daily:prev_odo field with the record pointer set to the same vehicle number for the current daily record (new record being created). The prev_odo field would have to be a creation field and not change if you edited the field later. This data would allow the calculation of MPG among other things and would relieve the driver of having to accurately remember the previous odometer reading for perhaps days. The drivers also change vehicles frequently, creating additional problem.
Drivers report on their daily/vehicle activity on a daily basis, because of internal accuracy and volumn problems
Any good way to do this in 3.04 without a ton of xbasic which might create on-site maintenance problems for me? They are about 35 miles from me and not at all computer literate.
Thank You
Ron Cottrell
Comment