C
Chuck216
Hi
I have a table with “TrainNumber†, “LastInspDate†, “LastInspHoursâ€,
“CurrentHours†and “Dateâ€.
On a form TrainNumber and Date are automatically filled in when the form is
opened. CurrentHours are filled in by the user as well as other data on the
form.
What I want to do is have access lookup the highest amount of hours in the
“CurrentHours†field and Date for the specific train in the table and fill
in the “LastInspDate†and “LastInspHours†with that data.
Any help with the will be gratefully appreciated.
Chuck
I have a table with “TrainNumber†, “LastInspDate†, “LastInspHoursâ€,
“CurrentHours†and “Dateâ€.
On a form TrainNumber and Date are automatically filled in when the form is
opened. CurrentHours are filled in by the user as well as other data on the
form.
What I want to do is have access lookup the highest amount of hours in the
“CurrentHours†field and Date for the specific train in the table and fill
in the “LastInspDate†and “LastInspHours†with that data.
Any help with the will be gratefully appreciated.
Chuck