Info won't populate in a report

A

Anita

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
 
M

Marshall Barton

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!
Click to expand...


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.
 
A

Anita

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
 
M

Marshall Barton

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.
Click to expand...
Click to expand...
 
A

Anita

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!
Click to expand...

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.
Click to expand...
Click to expand...
Click to expand...
 
M

Marshall Barton

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.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populated fields from a form 2
Populate Chart/Graph Using Report Fields 1
Form filter with multi-column combo box in report 0
Form filter with multi-column combo box does not work in report 0
Should I base my report on a form or a query? 2
Summing in a Report Footer 7
How do I make an average on a report out of formula totals? 2
Odd behaviour with a userform 0

Top