D Look Up

[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.

 

[Rick Brandt]

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.

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