S
sps2
I'm doing pretty well so far, for guessing and reading allot but I
can't figure this out.
I created a DB to track multiple vehicles and their fuel stops but
can't figure out how to tell the code to look up the previous mileage
of a specific vehicle using...
=DLookUp("[Mileage]","Fuel","[FuelID]=" & [FuelID]-1)
Obviously it just grabs the previous mileage that was entered
regardless which vehicle I am on.
There is one table for vehicles and one table for fuel linked using
[VehicleID]
I want it to lookup the mileage from the pervious record of the vehicle
that I am currently on.
Hope that makes cents.
can't figure this out.
I created a DB to track multiple vehicles and their fuel stops but
can't figure out how to tell the code to look up the previous mileage
of a specific vehicle using...
=DLookUp("[Mileage]","Fuel","[FuelID]=" & [FuelID]-1)
Obviously it just grabs the previous mileage that was entered
regardless which vehicle I am on.
There is one table for vehicles and one table for fuel linked using
[VehicleID]
I want it to lookup the mileage from the pervious record of the vehicle
that I am currently on.
Hope that makes cents.