Learning Queries

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

Guest

I have been trying to learn Access from a Microsft book. I am still trying to understand how to use queries. I created a database that have a table A that is a question and answer of "yes, no, n/a". The other table is a comment table with the same questions, but you are able to imput comments to why the answer is no.

I don't know if I have to create a query to link the two tables so Table A question 1 is related to Table B question 1. The purpose for me doing this is so I can create simple reports and charts that will list the no answers and then the comments to then no answers.

Can someone help guide me through this process or is there a better book that I can use to learn more about what I am doing.

thank you

Dan
 
You could create a query for this.

While in design view, add the two tables to your query. If there is not a
link between the two, you will have to click the "questionnumber" field in
one table and drag it to the "questionnumber" field in the other table. A
line should appear between the two tables.

Now, grab whichever fields you want from the tables and drag them to the
bottom of the screen so they each get a column. You only need
"questionnumber" once. Don't pull it from both tables.

Now, under the "answer" filed, in the criteria, put... "No"
This will cause only no responses to pull.

HTH
Rick


I have been trying to learn Access from a Microsft book. I am still trying
to understand how to use queries. I created a database that have a table A
that is a question and answer of "yes, no, n/a". The other table is a
comment table with the same questions, but you are able to imput comments to
why the answer is no.

I don't know if I have to create a query to link the two tables so Table A
question 1 is related to Table B question 1. The purpose for me doing this
is so I can create simple reports and charts that will list the no answers
and then the comments to then no answers.

Can someone help guide me through this process or is there a better book
that I can use to learn more about what I am doing.

thank you,

Dan
 
Back
Top