Survey Results

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

Guest

I have a survey that has about 30 questions. the surveys are typed in from
their origional paper form. each questions is very descriptive. the answers
to the questions is a choice of 5 answers, (tblScore) SA, A, NO, D, and SD.
on my survey table each questions has a lookup to the tblScore and one of the
answers can be chosen.

now, i would like to have a query that shows me for the total of all
respondents how many answered SA, A, NO, D or SD for each question.

I know how to create crosstabs or groupings. so please, if you respond, make
sure you try out your solution. cause i am having a lot of difficulty reading
all of these forums. i spent a lot of time looking on the internet in my book
collection and in Barnes and Noble. please help. thanks, Sam
 
thanks for your concern and speedy reply. here are the structure of my tables:

EmployeeSurveyResultsTbl
(FieldName, Answer)
Survey Number, 2 Gender, Female Age Group, 41-55 Years on the Job,
Facility, xxx Department, xxx Position, 9999 Shift, 11 to 7 Department
Supervisor, Question 1-1, A Question 1-2, SA Question 1-3, A Question 1-4,
A Question 1-5, SA Question 1-6, SA Question 1-7, A Question 1-8, NO Question
1-9, A Question 1-10, A Question 1-11, SA Question 1-12, A Question 2-1, NO
Question 2-2, A Question 2-3, A Question 2-4, NO Question 2-5, NO Question
3-1, A Question 3-2, A Question 3-3, A Question 3-4, A Question 3-5, A
Question 3-6, A Question 3-7, NO Question 3-8, A Question 3-9, A Question
3-10, A Question 3-11, A Question 3-12, A Question 3-13, A Question 4-1, NO
Question 4-2, A Question 4-3, A Question 4-4, NO Question 4-5, A Question
4-6, NO Question 4-7, A

All fields marked question are based on some question that is not specified
in my table, they are written out on the survey paper that distributed to
employees.

I have another table

ScoreTbl
with one field Score
Score stores five records: SA, A, NO, D, SD

Eache question is looks up via list box the score field of my score table.
thefore there are five possibilities for each question.

I would like to query all my records in my survey table so that i know how
many times (Count) SA is in Question 1-1 And so on for all my questions.

solution 1:
create a query linking the two tables score to question 1-1 and then count
question 1-1. that will do it for one question at a time. i would like to
have done for all question in one query.

did i explain myself enough?

thanks again,

Sam
 
thanks for your concern and speedy reply. here are the structure of my tables:

EmployeeSurveyResultsTbl
(FieldName, Answer)
Survey Number, 2 Gender, Female Age Group, 41-55 Years on the Job,
Facility, xxx Department, xxx Position, 9999 Shift, 11 to 7 Department
Supervisor, Question 1-1, A Question 1-2, SA Question 1-3, A Question 1-4,
A Question 1-5, SA Question 1-6, SA Question 1-7, A Question 1-8, NO Question
1-9, A Question 1-10, A Question 1-11, SA Question 1-12, A Question 2-1, NO
Question 2-2, A Question 2-3, A Question 2-4, NO Question 2-5, NO Question
3-1, A Question 3-2, A Question 3-3, A Question 3-4, A Question 3-5, A
Question 3-6, A Question 3-7, NO Question 3-8, A Question 3-9, A Question
3-10, A Question 3-11, A Question 3-12, A Question 3-13, A Question 4-1, NO
Question 4-2, A Question 4-3, A Question 4-4, NO Question 4-5, A Question
4-6, NO Question 4-7, A

All fields marked question are based on some question that is not specified
in my table, they are written out on the survey paper that distributed to
employees.

I have another table

ScoreTbl
with one field Score
Score stores five records: SA, A, NO, D, SD

Eache question is looks up via list box the score field of my score table.
thefore there are five possibilities for each question.

I would like to query all my records in my survey table so that i know how
many times (Count) SA is in Question 1-1 And so on for all my questions.

solution 1:
create a query linking the two tables score to question 1-1 and then count
question 1-1. that will do it for one question at a time. i would like to
have done for all question in one query.

did i explain myself enough?

thanks again,

Sam
 
Your issue is your table structure which is not normalized. Take a look at
the link I provided. You can create a similar structure by using a union
query to normalize your results table.
 
thanks Duane,

I am familiar with normalization, however, i can't seem to figure out what i
am violating. i have already downloaded the same database you posted, but i
don't see to what you are directing me to. Can you please be more specific to
which part of your survey would you recommend that i look at. also, is it
possible that you tell me what my table structure violates as far as
normalization so that i can work on improving it.

thanks so much,

sam
 
It looks like you have separate fields for each question. At Your Survey
stores questions as records. That is a huge difference.
 
hi duane,

I am writing back as a thanks and as a public service. based on your
recomendation and on the link you sent me i added a table and now i can
either run a select or better yet a cross tab to organize my data.

i now have three tables: 1. primary key survey number 2. primary key survey
response ID (actually, i use the response instead of ID) 3. primary keys
survey ID and question ID. works fine now.

although it makes sense to me (and i thought about changing to this
structure before i contacted you) it seems a bit weird. specifically, i can't
figure out what i voilated in normalization theory. if you can add this to
this post that would be wonderful. otherwise, i am happy to say that you have
helped me a lot, and i think if another developer runs in to this issue with
surveys, consider reading the string of these posts.

thanks,

sam
 
My thoughts on normalization is solely based on your use of repeating field
types. Take a look at your survey as an Order such as found in Northwind.
Your order table would have 30 fields for products purchased: Product1,
Product2, Product3,...Product30. At Your Survey is a bit more like the
Orders and OrderDetails table in Northwind. It is easy to add more products
without changing tables, forms, etc.
 
Hi

I am working on the following for two days. I already got my new tables
going, and i have my crosstab producing very good results. now i don't know
how to the input. i have a main form that has the survey information (ID,
Gender, Organization etc...) then i have a subform that has each question
(mutliple choice). i looked at your evaluate database but mine is different.
i want to show all questions for each survey. i don't want the user to select
the question and then answer. you call my questions "factors" and then you
have a rating. that is all i have, is question and rating. however, i want
all my factors to show up on the screen on entry.

plz lemme know,

thanks,

sam
 
If you want all your "factors to show up on the screen on entry" then you
would need to change the combo box to a list box or option group. Keep in
mind the combo box was used in my survey because each question had different
options.

Do all of your responses have the same response list? Are these numbered 1,
2, 3,...?
 

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

Prefilled Outlook Yes Voting Button response 0
Access Newbie trying to create Access Database for survey data 0
Likert Scale data- how to enter in Access 4
Survey 8
How to query survey responses from a table by question id 1
Counting survey responses, 4 queries or 1 query?? 1
Combine results using query 4
Inspection Database Design Help Please 0

Back
Top