Report Summary

[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

 

[Duane Hookom]

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"

 

[Guest]

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.

 

[Duane Hookom]

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?

 

[Guest]

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]

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?

 

[Guest]

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?

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

 

[Guest]

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.

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?

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

 

[Duane Hookom]

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.

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?

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