I 'm trying to use dlookup table in my queries, but can't work it out, can anybody help me ? can I use Queries! for active query ?
What's wrong with the expression below:
Dlookup ("[grade]", "[grading]", "[Expr1]= Queries![Expr1]")
i intend to look up the values in the "grade" field in the "grading" table, and the value of Expr1 in the table same as the value in the Expr1 field in the active query.
What's wrong with the expression below:
Dlookup ("[grade]", "[grading]", "[Expr1]= Queries![Expr1]")
i intend to look up the values in the "grade" field in the "grading" table, and the value of Expr1 in the table same as the value in the Expr1 field in the active query.
