Survey Reporting

  • Thread starter Thread starter Rachel
  • Start date Start date
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.
 
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.
 
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?
 
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...
 
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...
 
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...
 
Back
Top