#Error Message

A

Anita

Good morning!

I have a report (rptNFORespondentCourseTrainerDate) that is tied to a query
(qryNFORespondentCourseTrainerDate). There are parameter questions set up
when I try to preview the report (Trainer date, begin date, end date, course
number). However, the report shows the #Error in my text boxes instead of
numbers and percentages. Here is my SQL query:

SELECT tblcourse.trainer, tblNFORespondent.coursedate,
tblNFORespondent.coursenumber, tblcourse.class,
Count(tblNFORespondent.RespondentNumber) AS CountOfRespondentNumber,
Sum(tblNFORespondent.Q1excellent) AS SumOfQ1excellent,
Sum(tblNFORespondent.Q2excellent) AS SumOfQ2excellent,
Sum(tblNFORespondent.Q3excellent) AS SumOfQ3excellent,
Sum(tblNFORespondent.Q1good) AS SumOfQ1good, Sum(tblNFORespondent.Q2good) AS
SumOfQ2good, Sum(tblNFORespondent.Q3good) AS SumOfQ3good,
Sum(tblNFORespondent.Q1fair) AS SumOfQ1fair, Sum(tblNFORespondent.Q2fair) AS
SumOfQ2fair, Sum(tblNFORespondent.Q3fair) AS SumOfQ3fair,
Sum(tblNFORespondent.Q1poor) AS SumOfQ1poor, Sum(tblNFORespondent.Q2poor) AS
SumOfQ2poor, Sum(tblNFORespondent.Q3poor) AS SumOfQ3poor,
Sum(tblNFORespondent.Q4veryclearly) AS SumOfQ4veryclearly,
Sum(tblNFORespondent.Q5veryclearly) AS SumOfQ5veryclearly,
Sum(tblNFORespondent.Q6veryclearly) AS SumOfQ6veryclearly,
Sum(tblNFORespondent.Q7veryclearly) AS SumOfQ7veryclearly,
Sum(tblNFORespondent.Q8veryclearly) AS SumOfQ8veryclearly,
Sum(tblNFORespondent.Q9veryclearly) AS SumOfQ9veryclearly,
Sum(tblNFORespondent.Q10veryclearly) AS SumOfQ10veryclearly,
Sum(tblNFORespondent.Q11veryclearly) AS SumOfQ11veryclearly,
Sum(tblNFORespondent.Q12veryclearly) AS SumOfQ12veryclearly,
Sum(tblNFORespondent.Q4somewhatclearly) AS SumOfQ4somewhatclearly,
Sum(tblNFORespondent.Q5somewhatclearly) AS SumOfQ5somewhatclearly,
Sum(tblNFORespondent.Q6somewhatclearly) AS SumOfQ6somewhatclearly,
Sum(tblNFORespondent.Q7somewhatclearly) AS SumOfQ7somewhatclearly,
Sum(tblNFORespondent.Q8somewhatclearly) AS SumOfQ8somewhatclearly,
Sum(tblNFORespondent.Q9somewhatclearly) AS SumOfQ9somewhatclearly,
Sum(tblNFORespondent.Q10somewhatclearly) AS SumOfQ10somewhatclearly,
Sum(tblNFORespondent.Q11somewhatclearly) AS SumOfQ11somewhatclearly,
Sum(tblNFORespondent.Q12somewhatclearly) AS SumOfQ12somewhatclearly,
Sum(tblNFORespondent.Q4notatall) AS SumOfQ4notatall,
Sum(tblNFORespondent.Q5notatall) AS SumOfQ5notatall,
Sum(tblNFORespondent.Q6notatall) AS SumOfQ6notatall,
Sum(tblNFORespondent.Q7notatall) AS SumOfQ7notatall,
Sum(tblNFORespondent.Q8notatall) AS SumOfQ8notatall,
Sum(tblNFORespondent.Q9notatall) AS SumOfQ9notatall,
Sum(tblNFORespondent.Q10notatall) AS SumOfQ10notatall,
Sum(tblNFORespondent.Q11notatall) AS SumOfQ11notatall,
Sum(tblNFORespondent.Q12notatall) AS SumOfQ12notatall
FROM tblcourse INNER JOIN tblNFORespondent ON (tblcourse.trainer =
tblNFORespondent.trainer) AND (tblcourse.class = tblNFORespondent.class) AND
(tblcourse.coursenumber = tblNFORespondent.coursenumber) AND
(tblcourse.coursedate = tblNFORespondent.coursedate)
GROUP BY tblcourse.trainer, tblNFORespondent.coursedate,
tblNFORespondent.coursenumber, tblcourse.class
HAVING (((tblcourse.trainer) Like [Trainer Name]) AND
((tblNFORespondent.coursedate) Between [Beginning Date] And [Ending Date])
AND ((tblNFORespondent.coursenumber)=[Forms]![ENTER COURSE
NUMBER]![coursenumber]));

I've done this lots of times so I can't figure out why I'm having this
problem. Can someone please help me????

Many thanks!
Anita
 
Top