D Look Up

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

Can the DLookUp function be used with a query vice a
table? I created the following expression:

DLookUp("[Status]","tblAttendance","[MemberID] ='" &
[UserID] & "' And [Date] = #3/18/2004#"

However, when I substitute the target "tblAttendance" for
a query called "qryAttendance", which pulls info from the
same table, but specifies an individual department
member...I get the #Error in the text box the expression
is loaded in.

Is it just not possible to use a query with DLookUp? I
was hoping that using a query vice a table (table has
about 2000 records) it would speed up the process.
 
Antonio said:
Can the DLookUp function be used with a query vice a
table? I created the following expression:

DLookUp("[Status]","tblAttendance","[MemberID] ='" &
[UserID] & "' And [Date] = #3/18/2004#"

However, when I substitute the target "tblAttendance" for
a query called "qryAttendance", which pulls info from the
same table, but specifies an individual department
member...I get the #Error in the text box the expression
is loaded in.

Is it just not possible to use a query with DLookUp? I
was hoping that using a query vice a table (table has
about 2000 records) it would speed up the process.
Click to expand...

There is something else wrong with your expression. Dlookup works just fine
against saved queries.
 
Back
Top