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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Queries and reports in access Need help please
read a book..... j/k....peace
|
#4
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|