DLookUp in a Query

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I want to use a DLookup in a Query. The table that the ChkServer is coming
from is in the Query, However the tblEmployees is not. Here is the field in
the Query.

SERVER: DLookUp("[EmpFirstName] & "" "" &
[EmpLastName]","tblEmployees","EmployeeID=tblChecks.ChkServer")

It's saying that it can't find tblChecks.ChkServer

Any help appreciated.
Thanks
DS
 
Try:
SERVER: DLookUp("[EmpFirstName] & ' ' & [EmpLastName]", "tblEmployees",
"EmployeeID=" & tblChecks.ChkServer)

This assumes EmployeeID is numeric. If it is text, try
SERVER: DLookUp("[EmpFirstName] & ' ' & [EmpLastName]", "tblEmployees",
"EmployeeID=""" & tblChecks.ChkServer & """")
 
Back
Top