Survey Results

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

If you suggest 'make sure you try out your solution' might I suggest you
provide your table structure. We have no idea if you have a normalized table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest you
provide your table structure. We have no idea if you have a normalized table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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


"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest you
provide your table structure. We have no idea if you have a normalized table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest you
provide your table structure. We have no idea if you have a normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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 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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest you
provide your table structure. We have no idea if you have a normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

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

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest
you
provide your table structure. We have no idea if you have a normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

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

"Duane Hookom" wrote:

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

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I suggest
you
provide your table structure. We have no idea if you have a normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

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.

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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

"Duane Hookom" wrote:

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

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I
suggest
you
provide your table structure. We have no idea if you have a
normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

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

"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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

"Duane Hookom" wrote:

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

--
Duane Hookom
MS Access MVP


"SAm" wrote in message
...
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


"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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

"Duane Hookom" wrote:

If you suggest 'make sure you try out your solution' might I
suggest
you
provide your table structure. We have no idea if you have a
normalized
table
structure or have "committed spreadsheet".

You might want to take a look at the At Your Survey demo at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
This
includes a report that counts the responses by question.

--
Duane Hookom
MS Access MVP
--

"SAm" wrote in message
...
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