If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error Message
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 |
Thread Tools | |
Display Modes | |
|
|