DLookup ??

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hello all,

I knew how to do it but forgot and can not find the DB where I used it
earlier.

I have a table with verhicle milage, and would like to find using dlookup
the last entered record of a certain vehicle, so I can calculate the covered
distance between the two records.

Table tblJobRecord
fVehicleID, fMilage,.........

does it look like DLOOKUP ([fMilage],"tblRecord",[fVehicleID]-1)

Could some one help me on the right track.

Thx,
 
Have you tried using Access/HELP for correct syntax on DLookup()?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top