Info won't populate in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report (BannerRespondent2) that pulls information from a query
(BannerRespondentCourseTrainerDate2). Within the report is a text box that's
supposed to populate with the number of people that checked the 'Excellent'
box. The field name/expression listed as the control source is
'SumOfQ6excellent' and the name is 'Text210'. For some reason this box isn't
populating.

I've checked my query and my table and made sure they're both pointing to
the right report and 'Q6excellent' is in both of them. I've rebuilt the
query and the table, deleted and recreated the text box lots of time and
zilch! Any suggestions??

Thanks!
Anita
 
Anita said:
I have a report (BannerRespondent2) that pulls information from a query
(BannerRespondentCourseTrainerDate2). Within the report is a text box that's
supposed to populate with the number of people that checked the 'Excellent'
box. The field name/expression listed as the control source is
'SumOfQ6excellent' and the name is 'Text210'. For some reason this box isn't
populating.

I've checked my query and my table and made sure they're both pointing to
the right report and 'Q6excellent' is in both of them. I've rebuilt the
query and the table, deleted and recreated the text box lots of time and
zilch!


Leave the report aside for now and make sure the query is
axtually calculating the SumOfQ6excellent field correctly.
If you need help with the query, please post a Copy/Paste of
the query's SQL statement.
 
Marsh,

Here's the query. I'm hoping everything else is calculating correctly too.
Let me know if you have any questions about what else is on this report.

SELECT tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class,
Count(tblBannerRespondent.RespondentNumber) AS CountOfRespondentNumber,
Sum(tblBannerRespondent.Q1stronglyagree) AS SumOfQ1stronglyagree,
Sum(tblBannerRespondent.Q2stronglyagree) AS SumOfQ2stronglyagree,
Sum(tblBannerRespondent.Q3stronglyagree) AS SumOfQ3stronglyagree,
Sum(tblBannerRespondent.Q4stronglyagree) AS SumOfQ4stronglyagree,
Sum(tblBannerRespondent.Q5stronglyagree) AS SumOfQ5stronglyagree,
Sum(tblBannerRespondent.Q1agree) AS SumOfQ1agree,
Sum(tblBannerRespondent.Q2agree) AS SumOfQ2agree,
Sum(tblBannerRespondent.Q3agree) AS SumOfQ3agree,
Sum(tblBannerRespondent.Q4agree) AS SumOfQ4agree,
Sum(tblBannerRespondent.Q5agree) AS SumOfQ5agree,
Sum(tblBannerRespondent.Q1noopinion) AS SumOfQ1noopinion,
Sum(tblBannerRespondent.Q2noopinion) AS SumOfQ2noopinion,
Sum(tblBannerRespondent.Q3noopinion) AS SumOfQ3noopinion,
Sum(tblBannerRespondent.Q4noopinion) AS SumOfQ4noopinion,
Sum(tblBannerRespondent.Q5noopinion) AS SumOfQ5noopinion,
Sum(tblBannerRespondent.Q1disagree) AS SumOfQ1disagree,
Sum(tblBannerRespondent.Q2disagree) AS SumOfQ2disagree,
Sum(tblBannerRespondent.Q3disagree) AS SumOfQ3disagree,
Sum(tblBannerRespondent.Q4disagree) AS SumOfQ4disagree,
Sum(tblBannerRespondent.Q5disagree) AS SumOfQ5disagree,
Sum(tblBannerRespondent.Q1stronglydisagree) AS SumOfQ1stronglydisagree,
Sum(tblBannerRespondent.Q2stronglydisagree) AS SumOfQ2stronglydisagree,
Sum(tblBannerRespondent.Q3stronglydisagree) AS SumOfQ3stronglydisagree,
Sum(tblBannerRespondent.Q4stronglydisagree) AS SumOfQ4stronglydisagree,
Sum(tblBannerRespondent.Q5stronglydisagree) AS SumOfQ5stronglydisagree,
Sum(tblBannerRespondent.Q11stronglyagree) AS SumOfQ11stronglyagree,
Sum(tblBannerRespondent.Q12stronglyagree) AS SumOfQ12stronglyagree,
Sum(tblBannerRespondent.Q13stronglyagree) AS SumOfQ13stronglyagree,
Sum(tblBannerRespondent.Q14stronglyagree) AS SumOfQ14stronglyagree,
Sum(tblBannerRespondent.Q11agree) AS SumOfQ11agree,
Sum(tblBannerRespondent.Q12agree) AS SumOfQ12agree,
Sum(tblBannerRespondent.Q13agree) AS SumOfQ13agree,
Sum(tblBannerRespondent.Q14agree) AS SumOfQ14agree,
Sum(tblBannerRespondent.Q11noopinion) AS SumOfQ11noopinion,
Sum(tblBannerRespondent.Q12noopinion) AS SumOfQ12noopinion,
Sum(tblBannerRespondent.Q13noopinion) AS SumOfQ13noopinion,
Sum(tblBannerRespondent.Q14noopinion) AS SumOfQ14noopinion,
Sum(tblBannerRespondent.Q11disagree) AS SumOfQ11disagree,
Sum(tblBannerRespondent.Q12disagree) AS SumOfQ12disagree,
Sum(tblBannerRespondent.Q13disagree) AS SumOfQ13disagree,
Sum(tblBannerRespondent.Q14disagree) AS SumOfQ14disagree,
Sum(tblBannerRespondent.Q11stronglydisagree) AS SumOfQ11stronglydisagree,
Sum(tblBannerRespondent.Q12stronglydisagree) AS SumOfQ12stronglydisagree,
Sum(tblBannerRespondent.Q13stronglydisagree) AS SumOfQ13stronglydisagree,
Sum(tblBannerRespondent.Q14stronglydisagree) AS SumOfQ14stronglydisagree,
Sum(tblBannerRespondent.Q15excellent) AS SumOfQ15excellent,
Sum(tblBannerRespondent.Q16verygood) AS SumOfQ16verygood,
Sum(tblBannerRespondent.Q17good) AS SumOfQ17good,
Sum(tblBannerRespondent.Q18fair) AS SumOfQ18fair,
Sum(tblBannerRespondent.Q19poor) AS SumOfQ19poor,
Sum(tblBannerRespondent.Q6excellent) AS SumOfQ6excellent,
Sum(tblBannerRespondent.Q7verygood) AS SumOfQ7verygood,
Sum(tblBannerRespondent.Q8good) AS SumOfQ8good,
Sum(tblBannerRespondent.Q9fair) AS SumOfQ9fair,
Sum(tblBannerRespondent.Q10poor) AS SumOfQ10poor
FROM tblcourse INNER JOIN tblBannerRespondent ON (tblcourse.trainer =
tblBannerRespondent.trainer) AND (tblcourse.coursenumber =
tblBannerRespondent.coursenumber) AND (tblcourse.coursedate =
tblBannerRespondent.coursedate)
GROUP BY tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class
HAVING (((tblcourse.trainer) Like [Trainer Name]) AND
((tblBannerRespondent.coursedate) Between [Beginning Date] And [Ending Date])
AND ((tblBannerRespondent.coursenumber)=[Forms]![ENTER COURSE
NUMBER]![coursenumber]));

Thanks for helping an SQL statement newbie. :-D
Anita
 
Two immediate observations jump out of that query: One, the
Having clause should be a WHERE clause; and Two, your data
tables are horribly unnormalized. What are you going to do
when someone decides to add another dozen questions to the
survey???

The HAVING vs WHERE may be the problem as you are grouping
in the data but then discarding the totals outside the date
range.

After changing HAVING to WHERE, can you verify that the
values are really incorrect by checking the values in the
two tables and manually calculating the offending total?

Since the date is not in the course table, a course might
have more than one date associated with it so you may also
need to remove the date field from both the SELECT and GROUP
BY clauses.
--
Marsh
MVP [MS Access]

Here's the query. I'm hoping everything else is calculating correctly too.
Let me know if you have any questions about what else is on this report.

SELECT tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class,
Count(tblBannerRespondent.RespondentNumber) AS CountOfRespondentNumber,
Sum(tblBannerRespondent.Q1stronglyagree) AS SumOfQ1stronglyagree,
Sum(tblBannerRespondent.Q2stronglyagree) AS SumOfQ2stronglyagree,
Sum(tblBannerRespondent.Q3stronglyagree) AS SumOfQ3stronglyagree,
Sum(tblBannerRespondent.Q4stronglyagree) AS SumOfQ4stronglyagree,
Sum(tblBannerRespondent.Q5stronglyagree) AS SumOfQ5stronglyagree,
Sum(tblBannerRespondent.Q1agree) AS SumOfQ1agree,
Sum(tblBannerRespondent.Q2agree) AS SumOfQ2agree,
Sum(tblBannerRespondent.Q3agree) AS SumOfQ3agree,
Sum(tblBannerRespondent.Q4agree) AS SumOfQ4agree,
Sum(tblBannerRespondent.Q5agree) AS SumOfQ5agree,
Sum(tblBannerRespondent.Q1noopinion) AS SumOfQ1noopinion,
Sum(tblBannerRespondent.Q2noopinion) AS SumOfQ2noopinion,
Sum(tblBannerRespondent.Q3noopinion) AS SumOfQ3noopinion,
Sum(tblBannerRespondent.Q4noopinion) AS SumOfQ4noopinion,
Sum(tblBannerRespondent.Q5noopinion) AS SumOfQ5noopinion,
Sum(tblBannerRespondent.Q1disagree) AS SumOfQ1disagree,
Sum(tblBannerRespondent.Q2disagree) AS SumOfQ2disagree,
Sum(tblBannerRespondent.Q3disagree) AS SumOfQ3disagree,
Sum(tblBannerRespondent.Q4disagree) AS SumOfQ4disagree,
Sum(tblBannerRespondent.Q5disagree) AS SumOfQ5disagree,
Sum(tblBannerRespondent.Q1stronglydisagree) AS SumOfQ1stronglydisagree,
Sum(tblBannerRespondent.Q2stronglydisagree) AS SumOfQ2stronglydisagree,
Sum(tblBannerRespondent.Q3stronglydisagree) AS SumOfQ3stronglydisagree,
Sum(tblBannerRespondent.Q4stronglydisagree) AS SumOfQ4stronglydisagree,
Sum(tblBannerRespondent.Q5stronglydisagree) AS SumOfQ5stronglydisagree,
Sum(tblBannerRespondent.Q11stronglyagree) AS SumOfQ11stronglyagree,
Sum(tblBannerRespondent.Q12stronglyagree) AS SumOfQ12stronglyagree,
Sum(tblBannerRespondent.Q13stronglyagree) AS SumOfQ13stronglyagree,
Sum(tblBannerRespondent.Q14stronglyagree) AS SumOfQ14stronglyagree,
Sum(tblBannerRespondent.Q11agree) AS SumOfQ11agree,
Sum(tblBannerRespondent.Q12agree) AS SumOfQ12agree,
Sum(tblBannerRespondent.Q13agree) AS SumOfQ13agree,
Sum(tblBannerRespondent.Q14agree) AS SumOfQ14agree,
Sum(tblBannerRespondent.Q11noopinion) AS SumOfQ11noopinion,
Sum(tblBannerRespondent.Q12noopinion) AS SumOfQ12noopinion,
Sum(tblBannerRespondent.Q13noopinion) AS SumOfQ13noopinion,
Sum(tblBannerRespondent.Q14noopinion) AS SumOfQ14noopinion,
Sum(tblBannerRespondent.Q11disagree) AS SumOfQ11disagree,
Sum(tblBannerRespondent.Q12disagree) AS SumOfQ12disagree,
Sum(tblBannerRespondent.Q13disagree) AS SumOfQ13disagree,
Sum(tblBannerRespondent.Q14disagree) AS SumOfQ14disagree,
Sum(tblBannerRespondent.Q11stronglydisagree) AS SumOfQ11stronglydisagree,
Sum(tblBannerRespondent.Q12stronglydisagree) AS SumOfQ12stronglydisagree,
Sum(tblBannerRespondent.Q13stronglydisagree) AS SumOfQ13stronglydisagree,
Sum(tblBannerRespondent.Q14stronglydisagree) AS SumOfQ14stronglydisagree,
Sum(tblBannerRespondent.Q15excellent) AS SumOfQ15excellent,
Sum(tblBannerRespondent.Q16verygood) AS SumOfQ16verygood,
Sum(tblBannerRespondent.Q17good) AS SumOfQ17good,
Sum(tblBannerRespondent.Q18fair) AS SumOfQ18fair,
Sum(tblBannerRespondent.Q19poor) AS SumOfQ19poor,
Sum(tblBannerRespondent.Q6excellent) AS SumOfQ6excellent,
Sum(tblBannerRespondent.Q7verygood) AS SumOfQ7verygood,
Sum(tblBannerRespondent.Q8good) AS SumOfQ8good,
Sum(tblBannerRespondent.Q9fair) AS SumOfQ9fair,
Sum(tblBannerRespondent.Q10poor) AS SumOfQ10poor
FROM tblcourse INNER JOIN tblBannerRespondent ON (tblcourse.trainer =
tblBannerRespondent.trainer) AND (tblcourse.coursenumber =
tblBannerRespondent.coursenumber) AND (tblcourse.coursedate =
tblBannerRespondent.coursedate)
GROUP BY tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class
HAVING (((tblcourse.trainer) Like [Trainer Name]) AND
((tblBannerRespondent.coursedate) Between [Beginning Date] And [Ending Date])
AND ((tblBannerRespondent.coursenumber)=[Forms]![ENTER COURSE
NUMBER]![coursenumber]));


Marshall Barton said:
Leave the report aside for now and make sure the query is
axtually calculating the SumOfQ6excellent field correctly.
If you need help with the query, please post a Copy/Paste of
the query's SQL statement.
 
How do I replace the HAVE clause with the WHERE clause? Just go into the SQL
and type over it?

How do I normalize my data tables? Unfortunately, every time they redo the
survey I have to create an entirely new form, report, query, etc. because we
keep all this info for historical purposes.

I have a Parameter query prompt for the date and the criteria is 'Between
[Beginning Date] And [Ending Date]'. I always use the same date for the
beginning and end dates so hopefully I won't have to remove it.

Thanks!
Anita


Marshall Barton said:
Two immediate observations jump out of that query: One, the
Having clause should be a WHERE clause; and Two, your data
tables are horribly unnormalized. What are you going to do
when someone decides to add another dozen questions to the
survey???

The HAVING vs WHERE may be the problem as you are grouping
in the data but then discarding the totals outside the date
range.

After changing HAVING to WHERE, can you verify that the
values are really incorrect by checking the values in the
two tables and manually calculating the offending total?

Since the date is not in the course table, a course might
have more than one date associated with it so you may also
need to remove the date field from both the SELECT and GROUP
BY clauses.
--
Marsh
MVP [MS Access]

Here's the query. I'm hoping everything else is calculating correctly too.
Let me know if you have any questions about what else is on this report.

SELECT tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class,
Count(tblBannerRespondent.RespondentNumber) AS CountOfRespondentNumber,
Sum(tblBannerRespondent.Q1stronglyagree) AS SumOfQ1stronglyagree,
Sum(tblBannerRespondent.Q2stronglyagree) AS SumOfQ2stronglyagree,
Sum(tblBannerRespondent.Q3stronglyagree) AS SumOfQ3stronglyagree,
Sum(tblBannerRespondent.Q4stronglyagree) AS SumOfQ4stronglyagree,
Sum(tblBannerRespondent.Q5stronglyagree) AS SumOfQ5stronglyagree,
Sum(tblBannerRespondent.Q1agree) AS SumOfQ1agree,
Sum(tblBannerRespondent.Q2agree) AS SumOfQ2agree,
Sum(tblBannerRespondent.Q3agree) AS SumOfQ3agree,
Sum(tblBannerRespondent.Q4agree) AS SumOfQ4agree,
Sum(tblBannerRespondent.Q5agree) AS SumOfQ5agree,
Sum(tblBannerRespondent.Q1noopinion) AS SumOfQ1noopinion,
Sum(tblBannerRespondent.Q2noopinion) AS SumOfQ2noopinion,
Sum(tblBannerRespondent.Q3noopinion) AS SumOfQ3noopinion,
Sum(tblBannerRespondent.Q4noopinion) AS SumOfQ4noopinion,
Sum(tblBannerRespondent.Q5noopinion) AS SumOfQ5noopinion,
Sum(tblBannerRespondent.Q1disagree) AS SumOfQ1disagree,
Sum(tblBannerRespondent.Q2disagree) AS SumOfQ2disagree,
Sum(tblBannerRespondent.Q3disagree) AS SumOfQ3disagree,
Sum(tblBannerRespondent.Q4disagree) AS SumOfQ4disagree,
Sum(tblBannerRespondent.Q5disagree) AS SumOfQ5disagree,
Sum(tblBannerRespondent.Q1stronglydisagree) AS SumOfQ1stronglydisagree,
Sum(tblBannerRespondent.Q2stronglydisagree) AS SumOfQ2stronglydisagree,
Sum(tblBannerRespondent.Q3stronglydisagree) AS SumOfQ3stronglydisagree,
Sum(tblBannerRespondent.Q4stronglydisagree) AS SumOfQ4stronglydisagree,
Sum(tblBannerRespondent.Q5stronglydisagree) AS SumOfQ5stronglydisagree,
Sum(tblBannerRespondent.Q11stronglyagree) AS SumOfQ11stronglyagree,
Sum(tblBannerRespondent.Q12stronglyagree) AS SumOfQ12stronglyagree,
Sum(tblBannerRespondent.Q13stronglyagree) AS SumOfQ13stronglyagree,
Sum(tblBannerRespondent.Q14stronglyagree) AS SumOfQ14stronglyagree,
Sum(tblBannerRespondent.Q11agree) AS SumOfQ11agree,
Sum(tblBannerRespondent.Q12agree) AS SumOfQ12agree,
Sum(tblBannerRespondent.Q13agree) AS SumOfQ13agree,
Sum(tblBannerRespondent.Q14agree) AS SumOfQ14agree,
Sum(tblBannerRespondent.Q11noopinion) AS SumOfQ11noopinion,
Sum(tblBannerRespondent.Q12noopinion) AS SumOfQ12noopinion,
Sum(tblBannerRespondent.Q13noopinion) AS SumOfQ13noopinion,
Sum(tblBannerRespondent.Q14noopinion) AS SumOfQ14noopinion,
Sum(tblBannerRespondent.Q11disagree) AS SumOfQ11disagree,
Sum(tblBannerRespondent.Q12disagree) AS SumOfQ12disagree,
Sum(tblBannerRespondent.Q13disagree) AS SumOfQ13disagree,
Sum(tblBannerRespondent.Q14disagree) AS SumOfQ14disagree,
Sum(tblBannerRespondent.Q11stronglydisagree) AS SumOfQ11stronglydisagree,
Sum(tblBannerRespondent.Q12stronglydisagree) AS SumOfQ12stronglydisagree,
Sum(tblBannerRespondent.Q13stronglydisagree) AS SumOfQ13stronglydisagree,
Sum(tblBannerRespondent.Q14stronglydisagree) AS SumOfQ14stronglydisagree,
Sum(tblBannerRespondent.Q15excellent) AS SumOfQ15excellent,
Sum(tblBannerRespondent.Q16verygood) AS SumOfQ16verygood,
Sum(tblBannerRespondent.Q17good) AS SumOfQ17good,
Sum(tblBannerRespondent.Q18fair) AS SumOfQ18fair,
Sum(tblBannerRespondent.Q19poor) AS SumOfQ19poor,
Sum(tblBannerRespondent.Q6excellent) AS SumOfQ6excellent,
Sum(tblBannerRespondent.Q7verygood) AS SumOfQ7verygood,
Sum(tblBannerRespondent.Q8good) AS SumOfQ8good,
Sum(tblBannerRespondent.Q9fair) AS SumOfQ9fair,
Sum(tblBannerRespondent.Q10poor) AS SumOfQ10poor
FROM tblcourse INNER JOIN tblBannerRespondent ON (tblcourse.trainer =
tblBannerRespondent.trainer) AND (tblcourse.coursenumber =
tblBannerRespondent.coursenumber) AND (tblcourse.coursedate =
tblBannerRespondent.coursedate)
GROUP BY tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class
HAVING (((tblcourse.trainer) Like [Trainer Name]) AND
((tblBannerRespondent.coursedate) Between [Beginning Date] And [Ending Date])
AND ((tblBannerRespondent.coursenumber)=[Forms]![ENTER COURSE
NUMBER]![coursenumber]));

Anita wrote:
I have a report (BannerRespondent2) that pulls information from a query
(BannerRespondentCourseTrainerDate2). Within the report is a text box that's
supposed to populate with the number of people that checked the 'Excellent'
box. The field name/expression listed as the control source is
'SumOfQ6excellent' and the name is 'Text210'. For some reason this box isn't
populating.

I've checked my query and my table and made sure they're both pointing to
the right report and 'Q6excellent' is in both of them. I've rebuilt the
query and the table, deleted and recreated the text box lots of time and
zilch!

Marshall Barton said:
Leave the report aside for now and make sure the query is
axtually calculating the SumOfQ6excellent field correctly.
If you need help with the query, please post a Copy/Paste of
the query's SQL statement.
 
Yes, just replace the word HAVING with the word WHERE. Then
rerun the query to see how things stand.

Normalizing your tables is a fairly deep topic that takes a
lot of thought. I suggest that you first read:
http://support.microsoft.com/kb/283878/en-us
and try to figure out a relational table structure using the
concepts in the article. If you have specific questions,
try posting to the tabledesign newsgroup or Google for
hundreds of other articles on the web.
--
Marsh
MVP [MS Access]

How do I replace the HAVE clause with the WHERE clause? Just go into the SQL
and type over it?

How do I normalize my data tables? Unfortunately, every time they redo the
survey I have to create an entirely new form, report, query, etc. because we
keep all this info for historical purposes.

I have a Parameter query prompt for the date and the criteria is 'Between
[Beginning Date] And [Ending Date]'. I always use the same date for the
beginning and end dates so hopefully I won't have to remove it.


Marshall Barton said:
Two immediate observations jump out of that query: One, the
Having clause should be a WHERE clause; and Two, your data
tables are horribly unnormalized. What are you going to do
when someone decides to add another dozen questions to the
survey???

The HAVING vs WHERE may be the problem as you are grouping
in the data but then discarding the totals outside the date
range.

After changing HAVING to WHERE, can you verify that the
values are really incorrect by checking the values in the
two tables and manually calculating the offending total?

Since the date is not in the course table, a course might
have more than one date associated with it so you may also
need to remove the date field from both the SELECT and GROUP
BY clauses.

Here's the query. I'm hoping everything else is calculating correctly too.
Let me know if you have any questions about what else is on this report.

SELECT tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class,
Count(tblBannerRespondent.RespondentNumber) AS CountOfRespondentNumber,
Sum(tblBannerRespondent.Q1stronglyagree) AS SumOfQ1stronglyagree,
Sum(tblBannerRespondent.Q2stronglyagree) AS SumOfQ2stronglyagree,
Sum(tblBannerRespondent.Q3stronglyagree) AS SumOfQ3stronglyagree,
Sum(tblBannerRespondent.Q4stronglyagree) AS SumOfQ4stronglyagree,
Sum(tblBannerRespondent.Q5stronglyagree) AS SumOfQ5stronglyagree,
Sum(tblBannerRespondent.Q1agree) AS SumOfQ1agree,
Sum(tblBannerRespondent.Q2agree) AS SumOfQ2agree,
Sum(tblBannerRespondent.Q3agree) AS SumOfQ3agree,
Sum(tblBannerRespondent.Q4agree) AS SumOfQ4agree,
Sum(tblBannerRespondent.Q5agree) AS SumOfQ5agree,
Sum(tblBannerRespondent.Q1noopinion) AS SumOfQ1noopinion,
Sum(tblBannerRespondent.Q2noopinion) AS SumOfQ2noopinion,
Sum(tblBannerRespondent.Q3noopinion) AS SumOfQ3noopinion,
Sum(tblBannerRespondent.Q4noopinion) AS SumOfQ4noopinion,
Sum(tblBannerRespondent.Q5noopinion) AS SumOfQ5noopinion,
Sum(tblBannerRespondent.Q1disagree) AS SumOfQ1disagree,
Sum(tblBannerRespondent.Q2disagree) AS SumOfQ2disagree,
Sum(tblBannerRespondent.Q3disagree) AS SumOfQ3disagree,
Sum(tblBannerRespondent.Q4disagree) AS SumOfQ4disagree,
Sum(tblBannerRespondent.Q5disagree) AS SumOfQ5disagree,
Sum(tblBannerRespondent.Q1stronglydisagree) AS SumOfQ1stronglydisagree,
Sum(tblBannerRespondent.Q2stronglydisagree) AS SumOfQ2stronglydisagree,
Sum(tblBannerRespondent.Q3stronglydisagree) AS SumOfQ3stronglydisagree,
Sum(tblBannerRespondent.Q4stronglydisagree) AS SumOfQ4stronglydisagree,
Sum(tblBannerRespondent.Q5stronglydisagree) AS SumOfQ5stronglydisagree,
Sum(tblBannerRespondent.Q11stronglyagree) AS SumOfQ11stronglyagree,
Sum(tblBannerRespondent.Q12stronglyagree) AS SumOfQ12stronglyagree,
Sum(tblBannerRespondent.Q13stronglyagree) AS SumOfQ13stronglyagree,
Sum(tblBannerRespondent.Q14stronglyagree) AS SumOfQ14stronglyagree,
Sum(tblBannerRespondent.Q11agree) AS SumOfQ11agree,
Sum(tblBannerRespondent.Q12agree) AS SumOfQ12agree,
Sum(tblBannerRespondent.Q13agree) AS SumOfQ13agree,
Sum(tblBannerRespondent.Q14agree) AS SumOfQ14agree,
Sum(tblBannerRespondent.Q11noopinion) AS SumOfQ11noopinion,
Sum(tblBannerRespondent.Q12noopinion) AS SumOfQ12noopinion,
Sum(tblBannerRespondent.Q13noopinion) AS SumOfQ13noopinion,
Sum(tblBannerRespondent.Q14noopinion) AS SumOfQ14noopinion,
Sum(tblBannerRespondent.Q11disagree) AS SumOfQ11disagree,
Sum(tblBannerRespondent.Q12disagree) AS SumOfQ12disagree,
Sum(tblBannerRespondent.Q13disagree) AS SumOfQ13disagree,
Sum(tblBannerRespondent.Q14disagree) AS SumOfQ14disagree,
Sum(tblBannerRespondent.Q11stronglydisagree) AS SumOfQ11stronglydisagree,
Sum(tblBannerRespondent.Q12stronglydisagree) AS SumOfQ12stronglydisagree,
Sum(tblBannerRespondent.Q13stronglydisagree) AS SumOfQ13stronglydisagree,
Sum(tblBannerRespondent.Q14stronglydisagree) AS SumOfQ14stronglydisagree,
Sum(tblBannerRespondent.Q15excellent) AS SumOfQ15excellent,
Sum(tblBannerRespondent.Q16verygood) AS SumOfQ16verygood,
Sum(tblBannerRespondent.Q17good) AS SumOfQ17good,
Sum(tblBannerRespondent.Q18fair) AS SumOfQ18fair,
Sum(tblBannerRespondent.Q19poor) AS SumOfQ19poor,
Sum(tblBannerRespondent.Q6excellent) AS SumOfQ6excellent,
Sum(tblBannerRespondent.Q7verygood) AS SumOfQ7verygood,
Sum(tblBannerRespondent.Q8good) AS SumOfQ8good,
Sum(tblBannerRespondent.Q9fair) AS SumOfQ9fair,
Sum(tblBannerRespondent.Q10poor) AS SumOfQ10poor
FROM tblcourse INNER JOIN tblBannerRespondent ON (tblcourse.trainer =
tblBannerRespondent.trainer) AND (tblcourse.coursenumber =
tblBannerRespondent.coursenumber) AND (tblcourse.coursedate =
tblBannerRespondent.coursedate)
GROUP BY tblcourse.trainer, tblBannerRespondent.coursedate,
tblBannerRespondent.coursenumber, tblcourse.class
HAVING (((tblcourse.trainer) Like [Trainer Name]) AND
((tblBannerRespondent.coursedate) Between [Beginning Date] And [Ending Date])
AND ((tblBannerRespondent.coursenumber)=[Forms]![ENTER COURSE
NUMBER]![coursenumber]));


Anita wrote:
I have a report (BannerRespondent2) that pulls information from a query
(BannerRespondentCourseTrainerDate2). Within the report is a text box that's
supposed to populate with the number of people that checked the 'Excellent'
box. The field name/expression listed as the control source is
'SumOfQ6excellent' and the name is 'Text210'. For some reason this box isn't
populating.

I've checked my query and my table and made sure they're both pointing to
the right report and 'Q6excellent' is in both of them. I've rebuilt the
query and the table, deleted and recreated the text box lots of time and
zilch!


:
Leave the report aside for now and make sure the query is
axtually calculating the SumOfQ6excellent field correctly.
If you need help with the query, please post a Copy/Paste of
the query's SQL statement.
 
Back
Top