DLookUp in a Query

[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

 

[Duane Hookom]

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 & """")

 

[DS]

Perfect Duane, The first one works perfectly.
Thanks.
DS