DLookup between two quries (1 Viewer)

I have a query named "qryStudentMarkTable" which include student marks and some calculation fields. Another GroupBy query "qryStudentYearResults" which includes some functions to find students final result and averages. In the second query there is a calculated field named "ResFCourse" which is calculated by public function. Now, I want to Dlookup "ResFCourse" to a first query filed named "Res1". I tried many scenarios of using Dlookupwith but no avails I use:


However, my code stuck with the following error

The recommended method is to join the queries with the field you are using as criteria for the dlookup.?

Saying that, qualify the criteria, you've qualified everything but that.
I do not believe you need to qualify for the dlookup field you are returning as that is done by the second parameter of the dlookup.

Gasman said:

The recommended method is to join the queries with the field you are using as criteria for the dlookup.?

Saying that, qualify the criteria, you've qualified everything but that.
I do not believe you need to qualify for the dlookup field you are returning as that is done by the second parameter of the dlookup.

Click to expand...

Ah! my poor idea, was that easy. !! So no need for DlookUp and no more headache . Many Thanks