Mysterious textbox in report

I had a query ("qry_student_mks") which had many
calculated fields including one named "Student_rank" for
calculation students rank/positions within their class
according to average marks. It used Dlookup to do this but
it produced inconsistent results. I then made a 2nd query
("qry_student_mks2")based on the 1st one to calculate
student rank using a subquery (select count(*).....)I
could not put this field in the 1st query due to a
circular reference error.

Since then, the "student_rank" textbox within a report
whose source is the 2nd query("qry_student_mks2")shows
#error.
HOWEVER, this 2nd query displays the correct results for
this field in its datasheet view.

What am I not doing right???PLease help.

Give it an alias in query design like

mystudentrank: dlookup("[rank]",...)

That is a different name than your first query for rank.

Martin

-----Original Message-----
I had a query ("qry_student_mks") which had many
calculated fields including one named "Student_rank" for
calculation students rank/positions within their class
according to average marks. It used Dlookup to do this
but
it produced inconsistent results. I then made a 2nd query
("qry_student_mks2")based on the 1st one to calculate
student rank using a subquery (select count(*).....)I
could not put this field in the 1st query due to a
circular reference error.

Since then, the "student_rank" textbox within a report
whose source is the 2nd query("qry_student_mks2")shows
#error.
HOWEVER, this 2nd query displays the correct results for
this field in its datasheet view.

What am I not doing right???PLease help.


.