J
Jared
I have a table containing service history for vehicles.
I'm trying to put together a report to display what services have been
completed on each vehicle for the current period & if the services were
carried out within a tolerance based on the vehicle mileage.
I've tried a few combinations of dlookup, attempted self join queries etc.
to determine the mileage of the service prior to the current one to work out
these intervals between services.
The second highest value in a query or dlookup/dmax seems to be beyond my
reach.
Could anyone point me in the best direction to overcome this?
Thankyou in advance.
I'm trying to put together a report to display what services have been
completed on each vehicle for the current period & if the services were
carried out within a tolerance based on the vehicle mileage.
I've tried a few combinations of dlookup, attempted self join queries etc.
to determine the mileage of the service prior to the current one to work out
these intervals between services.
The second highest value in a query or dlookup/dmax seems to be beyond my
reach.
Could anyone point me in the best direction to overcome this?
Thankyou in advance.