Survey Reporting

R

Rachel

I am using the "At your Survey" created by Duane Hookum.
I have a report that I like and want to add additional
pieces to. I want my report to look like this:

Survey Results by Respondent

Respondent: 3X78Y
Question# Question Text
------------------------------------------------------

Survey: S1
Survey Description: Survey 1

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S2
Survey Description: Survey 2

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S26
Survey Description: Survey 26

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

I want the report to include all surveys the respondent
answered to but exclude any surveys from the report that
the repondent was not given/has answers for.

Thanks.
 
D

Duane Hookom

You should be able to create a report based on a query like:
SELECT SELECT SrvName, RspnsName, QstnLvl1, QstnLvl2, QstnLvl3, QstnText,
Rspns
FROM tblQuestions
INNER JOIN ((tblSurveys
INNER JOIN tblSrvRspns ON tblSurveys.SrvID = tblSrvRspns.SrvID)
INNER JOIN tblResponses ON tblSrvRspns.RspnsID = tblResponses.RspnsID)
ON tblQuestions.QstnID = tblResponses.QstnID;
In your report's sorting and grouping, set the first level to RspnsName.
Then SrvName and your question levels.
 
G

Guest

I tried running the query with this:

SELECT tblSurveys.SrvName, tblSurveys.SrvDescription,
tblSrvRspns.RspnsID, tblSrvRspns.RspnsName,
tblQuestions.QstnLvl1, tblQuestions.QstnText,
tblResponses.Rspns
FROM [Object Definition], tblSrvRspns
INNER JOIN tblResponses
ON tblSrvRspns.RspnsID = tblResponses.RspnsID, tblSurveys
INNER JOIN tblQuestions
ON tblSurveys.SrvID = tblQuestions.SrvID;

I get a long list of RSPNSID = "1" with RspnsName
="qusdfkjh" all the way through. The SrvName, Srv
Description, QstnText, and QstnLvl1 changes but the
RSPNSID and RspnsName are exactly the same all the way
down. Any ideas why? Do my relationships have anything
to do with it?
 
D

Duane Hookom

Did you try the sql that I suggested?

--
Duane Hookom
MS Access MVP


I tried running the query with this:

SELECT tblSurveys.SrvName, tblSurveys.SrvDescription,
tblSrvRspns.RspnsID, tblSrvRspns.RspnsName,
tblQuestions.QstnLvl1, tblQuestions.QstnText,
tblResponses.Rspns
FROM [Object Definition], tblSrvRspns
INNER JOIN tblResponses
ON tblSrvRspns.RspnsID = tblResponses.RspnsID, tblSurveys
INNER JOIN tblQuestions
ON tblSurveys.SrvID = tblQuestions.SrvID;

I get a long list of RSPNSID = "1" with RspnsName
="qusdfkjh" all the way through. The SrvName, Srv
Description, QstnText, and QstnLvl1 changes but the
RSPNSID and RspnsName are exactly the same all the way
down. Any ideas why? Do my relationships have anything
to do with it?
-----Original Message-----
You should be able to create a report based on a query like:
SELECT SELECT SrvName, RspnsName, QstnLvl1, QstnLvl2, QstnLvl3, QstnText,
Rspns
FROM tblQuestions
INNER JOIN ((tblSurveys
INNER JOIN tblSrvRspns ON tblSurveys.SrvID = tblSrvRspns.SrvID)
INNER JOIN tblResponses ON tblSrvRspns.RspnsID = tblResponses.RspnsID)
ON tblQuestions.QstnID = tblResponses.QstnID;
In your report's sorting and grouping, set the first level to RspnsName.
Then SrvName and your question levels.

--
Duane Hookom
MS Access MVP





.
Click to expand...
Click to expand...
 
R

Rachel

Yes, I finally got something to work! Now, how do I get
rid of duplicate records? The reports is in the format
that I want but I get 5 - 10 pages worth of duplicate
entries for each survey. About 20 copies of each question
with it's repective answer for each survey. Is there any
way I can get a direct email from you so that I can send
you some snapshots of what I see? My email is
(e-mail address removed).

Thanks Duane!
-----Original Message-----
Did you try the sql that I suggested?

--
Duane Hookom
MS Access MVP


I tried running the query with this:

SELECT tblSurveys.SrvName, tblSurveys.SrvDescription,
tblSrvRspns.RspnsID, tblSrvRspns.RspnsName,
tblQuestions.QstnLvl1, tblQuestions.QstnText,
tblResponses.Rspns
FROM [Object Definition], tblSrvRspns
INNER JOIN tblResponses
ON tblSrvRspns.RspnsID = tblResponses.RspnsID, tblSurveys
INNER JOIN tblQuestions
ON tblSurveys.SrvID = tblQuestions.SrvID;

I get a long list of RSPNSID = "1" with RspnsName
="qusdfkjh" all the way through. The SrvName, Srv
Description, QstnText, and QstnLvl1 changes but the
RSPNSID and RspnsName are exactly the same all the way
down. Any ideas why? Do my relationships have anything
to do with it?
-----Original Message-----
You should be able to create a report based on a query like:
SELECT SELECT SrvName, RspnsName, QstnLvl1, QstnLvl2, QstnLvl3, QstnText,
Rspns
FROM tblQuestions
INNER JOIN ((tblSurveys
INNER JOIN tblSrvRspns ON tblSurveys.SrvID = tblSrvRspns.SrvID)
INNER JOIN tblResponses ON tblSrvRspns.RspnsID = tblResponses.RspnsID)
ON tblQuestions.QstnID = tblResponses.QstnID;
In your report's sorting and grouping, set the first level to RspnsName.
Then SrvName and your question levels.

--
Duane Hookom
MS Access MVP


I am using the "At your Survey" created by Duane Hookum.
I have a report that I like and want to add additional
pieces to. I want my report to look like this:

Survey Results by Respondent

Respondent: 3X78Y
Question# Question Text
----------------------------------------------------- -

Survey: S1
Survey Description: Survey 1

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S2
Survey Description: Survey 2

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S26
Survey Description: Survey 26

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

I want the report to include all surveys the respondent
answered to but exclude any surveys from the report that
the repondent was not given/has answers for.

Thanks.


.
Click to expand...
Click to expand...


.
Click to expand...
 
D

Duane Hookom

What SQL are you using?

--
Duane Hookom
Microsoft Access MVP
Please direct any questions to News Groups


Rachel said:
Yes, I finally got something to work! Now, how do I get
rid of duplicate records? The reports is in the format
that I want but I get 5 - 10 pages worth of duplicate
entries for each survey. About 20 copies of each question
with it's repective answer for each survey. Is there any
way I can get a direct email from you so that I can send
you some snapshots of what I see? My email is
(e-mail address removed).

Thanks Duane!
-----Original Message-----
Did you try the sql that I suggested?

--
Duane Hookom
MS Access MVP


I tried running the query with this:

SELECT tblSurveys.SrvName, tblSurveys.SrvDescription,
tblSrvRspns.RspnsID, tblSrvRspns.RspnsName,
tblQuestions.QstnLvl1, tblQuestions.QstnText,
tblResponses.Rspns
FROM [Object Definition], tblSrvRspns
INNER JOIN tblResponses
ON tblSrvRspns.RspnsID = tblResponses.RspnsID, tblSurveys
INNER JOIN tblQuestions
ON tblSurveys.SrvID = tblQuestions.SrvID;

I get a long list of RSPNSID = "1" with RspnsName
="qusdfkjh" all the way through. The SrvName, Srv
Description, QstnText, and QstnLvl1 changes but the
RSPNSID and RspnsName are exactly the same all the way
down. Any ideas why? Do my relationships have anything
to do with it?
-----Original Message-----
You should be able to create a report based on a query
like:
SELECT SELECT SrvName, RspnsName, QstnLvl1, QstnLvl2,
QstnLvl3, QstnText,
Rspns
FROM tblQuestions
INNER JOIN ((tblSurveys
INNER JOIN tblSrvRspns ON tblSurveys.SrvID =
tblSrvRspns.SrvID)
INNER JOIN tblResponses ON tblSrvRspns.RspnsID =
tblResponses.RspnsID)
ON tblQuestions.QstnID = tblResponses.QstnID;
In your report's sorting and grouping, set the first
level to RspnsName.
Then SrvName and your question levels.

--
Duane Hookom
MS Access MVP


message
I am using the "At your Survey" created by Duane Hookum.
I have a report that I like and want to add additional
pieces to. I want my report to look like this:

Survey Results by Respondent

Respondent: 3X78Y
Question# Question Text
----------------------------------------------------- -

Survey: S1
Survey Description: Survey 1

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S2
Survey Description: Survey 2

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

Survey: S26
Survey Description: Survey 26

01 Overall ability to.....
02 Knowledge of .....
03 Ability to ....

I want the report to include all surveys the respondent
answered to but exclude any surveys from the report that
the repondent was not given/has answers for.

Thanks.


.
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

Creating a report from a crosstab query 1
Have results from survey display in report 4
Tabulate Survey Results in Excel 2003 2
Create Survey form in Access based on two linked forms 2
reporting based on a question from a survey 1
Grouping Count - Text Change 1
At Your Survey: Calculate field in cros-tab queries 1
Import of 50+ Survey Data Results 5

Top