I think it is the GROUP BY not being equal to anything. I want totals of
all grades from each student. I don't know what to make studentID equal to
(studentID=studentID? Of course not).

=(SELECT Sum([qryCourseGradeDistribution].[current average]) FROM
[qryCourseGradeDistribution] GROUP BY
[qryCourseGradeDistribution].[student])

How can I get around this problem? The text box DOES HAVE a unique name
prefixed with"txt".
Thanks.
RH