Report Summary

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

Guest

I am working on a report that would show the result of a questionnaire. I am
currently showing all the result summary for each question in a continous
report. Is it possible that I could make a summary to show which question is
lower than a certain score at the top of the report as follows:

Section 1 Score: 2 Bad Question: 1
Section 2 Score: 3 Bad Question: 5, 6, 7
.... and so on
 
hi, I have tried the function and apparently it doesn't seem to work for a
continouos form. I want to have a section that could provide that info. for
a lower header. :) Thanks in advance.
 
I think that it should work. You haven't provided near enough information to
prove me wrong. Are you refering to a continuous report or a continuous
form? What expression did you use in the control sources? What is your table
structure? What is the SQL of the query you would use to identify Bad
Questions?
 
I am refering to a continous summary report. The report has 5 sections.
Each section has around 4 to 5 questions (I have followed your At Your Survey
database format). At the "Section footer" of the report, I have entered your
code
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =" &
[sectionID])

The result is an error message of Run-time error '3075'
"Syntax error (missing operator) in query expression
'sectionID=Section1-company'.

I haven't tried the differentiate the bad question yet as the bad question
depends on the median of a question (which I have created a module based on a
separate query to calculate for each question on the form). I have tried
your code at a form and it has no problem. :) Please let know what I have not
done correctly. Thanks in advance.
 
Apparently SectionID is text, try treat it like text rather than a number:
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =""" &
[sectionID] & """")

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
I am refering to a continous summary report. The report has 5 sections.
Each section has around 4 to 5 questions (I have followed your At Your
Survey
database format). At the "Section footer" of the report, I have entered
your
code
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =" &
[sectionID])

The result is an error message of Run-time error '3075'
"Syntax error (missing operator) in query expression
'sectionID=Section1-company'.

I haven't tried the differentiate the bad question yet as the bad question
depends on the median of a question (which I have created a module based
on a
separate query to calculate for each question on the form). I have tried
your code at a form and it has no problem. :) Please let know what I have
not
done correctly. Thanks in advance.


Duane Hookom said:
I think that it should work. You haven't provided near enough information
to
prove me wrong. Are you refering to a continuous report or a continuous
form? What expression did you use in the control sources? What is your
table
structure? What is the SQL of the query you would use to identify Bad
Questions?
Click to expand...
Click to expand...
 
okay, now the run-time error '3061' happens: "Too few parameters. Expected 2."

This line of code is highlighted:
Set rs = db.OpenRecordset(pstrSQL)

I believe that it's because it's based on a parameter query with the
following criteria:
Between [forms]![update]![text1] And [forms]![update]![Filestartdate2]

What should I do to make it work? :)

Duane Hookom said:
Apparently SectionID is text, try treat it like text rather than a number:
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =""" &
[sectionID] & """")

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
I am refering to a continous summary report. The report has 5 sections.
Each section has around 4 to 5 questions (I have followed your At Your
Survey
database format). At the "Section footer" of the report, I have entered
your
code
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =" &
[sectionID])

The result is an error message of Run-time error '3075'
"Syntax error (missing operator) in query expression
'sectionID=Section1-company'.

I haven't tried the differentiate the bad question yet as the bad question
depends on the median of a question (which I have created a module based
on a
separate query to calculate for each question on the form). I have tried
your code at a form and it has no problem. :) Please let know what I have
not
done correctly. Thanks in advance.


Duane Hookom said:
I think that it should work. You haven't provided near enough information
to
prove me wrong. Are you refering to a continuous report or a continuous
form? What expression did you use in the control sources? What is your
table
structure? What is the SQL of the query you would use to identify Bad
Questions?

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
hi, I have tried the function and apparently it doesn't seem to work
for a
continouos form. I want to have a section that could provide that
info.
for
a lower header. :) Thanks in advance.

:

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
This
function can be used in the control source of a text box to display
values
from multiple records.

--
Duane Hookom
MS Access MVP


"questionnaire database analyst"
message
I am working on a report that would show the result of a
questionnaire.
I
am
currently showing all the result summary for each question in a
continous
report. Is it possible that I could make a summary to show which
question
is
lower than a certain score at the top of the report as follows:

Section 1 Score: 2 Bad Question: 1
Section 2 Score: 3 Bad Question: 5, 6, 7
... and so on
Click to expand...
Click to expand...
Click to expand...
 
I have solved the problem after removing the parameter!!! you are awesome!!
Now I am trying to show the question number only when the median of the
question is lower than 2. I was able to calculate the median with the median
function in the report with a module and a separate query. Any ideas how
that median function could fit together with your code? :) thanks in advance.

questionnaire database analyst said:
okay, now the run-time error '3061' happens: "Too few parameters. Expected 2."

This line of code is highlighted:
Set rs = db.OpenRecordset(pstrSQL)

I believe that it's because it's based on a parameter query with the
following criteria:
Between [forms]![update]![text1] And [forms]![update]![Filestartdate2]

What should I do to make it work? :)

Duane Hookom said:
Apparently SectionID is text, try treat it like text rather than a number:
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =""" &
[sectionID] & """")

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
I am refering to a continous summary report. The report has 5 sections.
Each section has around 4 to 5 questions (I have followed your At Your
Survey
database format). At the "Section footer" of the report, I have entered
your
code
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID =" &
[sectionID])

The result is an error message of Run-time error '3075'
"Syntax error (missing operator) in query expression
'sectionID=Section1-company'.

I haven't tried the differentiate the bad question yet as the bad question
depends on the median of a question (which I have created a module based
on a
separate query to calculate for each question on the form). I have tried
your code at a form and it has no problem. :) Please let know what I have
not
done correctly. Thanks in advance.


:

I think that it should work. You haven't provided near enough information
to
prove me wrong. Are you refering to a continuous report or a continuous
form? What expression did you use in the control sources? What is your
table
structure? What is the SQL of the query you would use to identify Bad
Questions?

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
hi, I have tried the function and apparently it doesn't seem to work
for a
continouos form. I want to have a section that could provide that
info.
for
a lower header. :) Thanks in advance.

:

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
This
function can be used in the control source of a text box to display
values
from multiple records.

--
Duane Hookom
MS Access MVP


"questionnaire database analyst"
message
I am working on a report that would show the result of a
questionnaire.
I
am
currently showing all the result summary for each question in a
continous
report. Is it possible that I could make a summary to show which
question
is
lower than a certain score at the top of the report as follows:

Section 1 Score: 2 Bad Question: 1
Section 2 Score: 3 Bad Question: 5, 6, 7
... and so on
Click to expand...
Click to expand...
Click to expand...
 
Can you calculate the median in your query?

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
I have solved the problem after removing the parameter!!! you are awesome!!
Now I am trying to show the question number only when the median of the
question is lower than 2. I was able to calculate the median with the
median
function in the report with a module and a separate query. Any ideas how
that median function could fit together with your code? :) thanks in
advance.

questionnaire database analyst said:
okay, now the run-time error '3061' happens: "Too few parameters.
Expected 2."

This line of code is highlighted:
Set rs = db.OpenRecordset(pstrSQL)

I believe that it's because it's based on a parameter query with the
following criteria:
Between [forms]![update]![text1] And [forms]![update]![Filestartdate2]

What should I do to make it work? :)

Duane Hookom said:
Apparently SectionID is text, try treat it like text rather than a
number:
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID
=""" &
[sectionID] & """")

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
message
I am refering to a continous summary report. The report has 5
sections.
Each section has around 4 to 5 questions (I have followed your At
Your
Survey
database format). At the "Section footer" of the report, I have
entered
your
code
=Concatenate("SELECT questionnumber FROM reportquery WHERE sectionID
=" &
[sectionID])

The result is an error message of Run-time error '3075'
"Syntax error (missing operator) in query expression
'sectionID=Section1-company'.

I haven't tried the differentiate the bad question yet as the bad
question
depends on the median of a question (which I have created a module
based
on a
separate query to calculate for each question on the form). I have
tried
your code at a form and it has no problem. :) Please let know what I
have
not
done correctly. Thanks in advance.


:

I think that it should work. You haven't provided near enough
information
to
prove me wrong. Are you refering to a continuous report or a
continuous
form? What expression did you use in the control sources? What is
your
table
structure? What is the SQL of the query you would use to identify
Bad
Questions?

--
Duane Hookom
MS Access MVP
--

"questionnaire database analyst"
message
hi, I have tried the function and apparently it doesn't seem to
work
for a
continouos form. I want to have a section that could provide that
info.
for
a lower header. :) Thanks in advance.

:

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
This
function can be used in the control source of a text box to
display
values
from multiple records.

--
Duane Hookom
MS Access MVP


"questionnaire database analyst"
message
I am working on a report that would show the result of a
questionnaire.
I
am
currently showing all the result summary for each question in a
continous
report. Is it possible that I could make a summary to show
which
question
is
lower than a certain score at the top of the report as follows:

Section 1 Score: 2 Bad Question: 1
Section 2 Score: 3 Bad Question: 5, 6, 7
... and so on
Click to expand...
Click to expand...
Click to expand...
 
Back
Top