A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Queries and reports in access Need help please



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2004, 03:46 AM
GabrielG
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

Hello everyone ,
I have a little issue to setup a database. I created a table with
approximately 20 columns. The columns have an entry of Yes or no base on a
questionnaire from survey. What can I do to get a result of my table I would
like to know how many "Yes" and "no" I have. I don't know how to add them or
get this information.

Thanks in advance
GABRIEL


  #2  
Old May 9th, 2004, 04:05 AM
Steve Schapel
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

Gabriel,

The first answer to your question is that your table structure is not
really the best for this situation, and it will be a lot easier if you
can set it up differently. Is your database design set in concrete, or
are you able to consider a revision?

By the way, posting to one, or at most 2 newsgroups is usually
sufficient to get a good help.

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
Hello everyone ,
I have a little issue to setup a database. I created a table with
approximately 20 columns. The columns have an entry of Yes or no base on a
questionnaire from survey. What can I do to get a result of my table I would
like to know how many "Yes" and "no" I have. I don't know how to add them or
get this information.

Thanks in advance
GABRIEL


  #3  
Old May 9th, 2004, 06:11 AM
Liggy
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

read a book..... j/k....peace
  #4  
Old May 9th, 2004, 07:16 AM
GabrielG
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

I can consider a revision . What do you recommend?
I need to find the best solution due to the fact that most likely I will be
doing some more of these projects. Like I said before the only data will be
Yes or no answers based on question. The goal will be how many yes and no
answers we can gather and have a nice report. any suggestions?

--
GABRIEL GOMEZ
"Steve Schapel" wrote in message
...
Gabriel,

The first answer to your question is that your table structure is not
really the best for this situation, and it will be a lot easier if you
can set it up differently. Is your database design set in concrete, or
are you able to consider a revision?

By the way, posting to one, or at most 2 newsgroups is usually
sufficient to get a good help.

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
Hello everyone ,
I have a little issue to setup a database. I created a table with
approximately 20 columns. The columns have an entry of Yes or no base on

a
questionnaire from survey. What can I do to get a result of my table I

would
like to know how many "Yes" and "no" I have. I don't know how to add

them or
get this information.

Thanks in advance
GABRIEL




  #5  
Old May 9th, 2004, 10:15 AM
Steve Schapel
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

Gabriel,

Your survey responses should be in a table with fields similar to...

RespondentID
QuestionNumber
YesNoAnswer

In other words, the answer to each question should be a separate record
in the table, rather than a separate field. So, to simplify, let's say
you have 2 people respond to the survey, and let's suppose the survey
only has 3 questions for the sake of illustration, then the data in the
table might look like this:

1 1 Yes
1 2 No
1 3 No
2 1 Yes
2 2 Yes
2 3 No

Get the idea? I know your database is probably more complex than this,
with information about the respondents in another table, and the
questions themselves listed in yet another table. But this way of
recording the responses will allow you to easilt create a query that
will show results such as...

Question Response Count
1 Yes 2
1 No 0
2 Yes 1
2 No 1
3 Yes 0
3 No 2

and from this you will be able to produce a "nice report".

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
I can consider a revision . What do you recommend?
I need to find the best solution due to the fact that most likely I will be
doing some more of these projects. Like I said before the only data will be
Yes or no answers based on question. The goal will be how many yes and no
answers we can gather and have a nice report. any suggestions?

  #6  
Old May 9th, 2004, 11:57 AM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

In addition to Steve's bang-on advice, you might go to
http://www.rogersaccesslibrary.com/OtherLibraries.asp and look for "At Your
Survey" in Duane Hookom's section.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Steve Schapel" wrote in message
...
Gabriel,

Your survey responses should be in a table with fields similar to...

RespondentID
QuestionNumber
YesNoAnswer

In other words, the answer to each question should be a separate record
in the table, rather than a separate field. So, to simplify, let's say
you have 2 people respond to the survey, and let's suppose the survey
only has 3 questions for the sake of illustration, then the data in the
table might look like this:

1 1 Yes
1 2 No
1 3 No
2 1 Yes
2 2 Yes
2 3 No

Get the idea? I know your database is probably more complex than this,
with information about the respondents in another table, and the
questions themselves listed in yet another table. But this way of
recording the responses will allow you to easilt create a query that
will show results such as...

Question Response Count
1 Yes 2
1 No 0
2 Yes 1
2 No 1
3 Yes 0
3 No 2

and from this you will be able to produce a "nice report".

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
I can consider a revision . What do you recommend?
I need to find the best solution due to the fact that most likely I will

be
doing some more of these projects. Like I said before the only data will

be
Yes or no answers based on question. The goal will be how many yes and

no
answers we can gather and have a nice report. any suggestions?



  #7  
Old May 10th, 2004, 11:32 PM
GabrielG
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

Thanks so much for the info. The link of this website contains a lot of good
info.
The way I have it setup is that I have a table with codes and I created a
form base on the table with options to select yes or no answer.
The hard part is to gather all this information and find out how many "Yes"
and "No" answers I have and have a nice report.
Thanks again.



--
GABRIEL GOMEZ
"Douglas J. Steele" wrote in message
...
In addition to Steve's bang-on advice, you might go to
http://www.rogersaccesslibrary.com/OtherLibraries.asp and look for "At

Your
Survey" in Duane Hookom's section.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Steve Schapel" wrote in message
...
Gabriel,

Your survey responses should be in a table with fields similar to...

RespondentID
QuestionNumber
YesNoAnswer

In other words, the answer to each question should be a separate record
in the table, rather than a separate field. So, to simplify, let's say
you have 2 people respond to the survey, and let's suppose the survey
only has 3 questions for the sake of illustration, then the data in the
table might look like this:

1 1 Yes
1 2 No
1 3 No
2 1 Yes
2 2 Yes
2 3 No

Get the idea? I know your database is probably more complex than this,
with information about the respondents in another table, and the
questions themselves listed in yet another table. But this way of
recording the responses will allow you to easilt create a query that
will show results such as...

Question Response Count
1 Yes 2
1 No 0
2 Yes 1
2 No 1
3 Yes 0
3 No 2

and from this you will be able to produce a "nice report".

--
Steve Schapel, Microsoft Access MVP


GabrielG wrote:
I can consider a revision . What do you recommend?
I need to find the best solution due to the fact that most likely I

will
be
doing some more of these projects. Like I said before the only data

will
be
Yes or no answers based on question. The goal will be how many yes and

no
answers we can gather and have a nice report. any suggestions?





  #8  
Old May 11th, 2004, 02:45 AM
Steve Schapel
external usenet poster
 
Posts: n/a
Default Queries and reports in access Need help please

Gabriel,

The way to "gather all this information" is to use a Totals Query. To
use the field names taken from the example I gave in my earlier reply,
just make a query based on your table, add the fields to the query
design grid in the order QuestionNumber, YesNoAnswer, RespondentID.
Make it a Totals Query (select Totals fromthe View menu), then in the
Totals row of the query design grid, leave Group By in the
QuestionNumber and YesNoAnswer columns, and enter Count in the
RespondentID column.

Then you can use the feilds from this query as the basis of your report.

If you need more specific help, you will need to give some more detailed
information about the fields you have now, and the way you want your
report to look, maybe with examples.

--
Steve Schapel, Microsoft Access MVP

GabrielG wrote:
Thanks so much for the info. The link of this website contains a lot of good
info.
The way I have it setup is that I have a table with codes and I created a
form base on the table with options to select yes or no answer.
The hard part is to gather all this information and find out how many "Yes"
and "No" answers I have and have a nice report.
Thanks again.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.