Search results

Sorry to keep posting, but if you know of any good articles on normalization and sound database structure and planning, please post them,.

Sorry if I posted another thread on this topic, if I did it was accidental. Anyway, I'm not sure what you mean by making them rows instead of columns. They are different questions that pertain to one record for each response. And I went to About.com for an article on normalization. Would it be...

count multiple yes/no records with a single query OK, here is another point I am stuck. I want to count multiple records with a single query. Here's the SQL View of the one I have now, that counts a field set. What I want to do is add more fields (say, fields A, B and C to the SQL statement but...

OK, here is another point I am stuck. I want to count multiple records with a single query. Here's the SQL View of the one I have now, that counts a field set. What I want to do is add more fields (say, fields A, B and C to the SQL statement but I suck with syntax. SELECT [survey...

Because I want to consolidate the results from all the queries into a report, and I need a place to store the information.

query results table-Merged thread I have a query_ReimburseResult that counts the yes/no answers in field Reimburse from tbl_Survey. How do I take the results from the query and put it into a field in another table? I have tbl_Result and a field called ReimburseResult. I set the type to long...

I should add that There are about 10 more fields that I am going to add to the results table. Is it possible to just write an append query that will bring the results from the rest of the queries together in one table?

I have a query_ReimburseResult that counts the yes/no answers in field Reimburse from tbl_Survey. How do I take the results from the query and put it into a field in another table? I have tbl_Result and a field called ReimburseResult. I set the type to long integer and then what? thanks!

ahh... SQL View?

I hate to ask, but yes, I need more explanation. You lost me after select. As in, I think I understand that it's a select query. But that's about it.

How can I set up a query to give me the total number of "yes" and "no" responses from a yes/no field?

ahhh that's what I figured. I ended up taking the easy route and just assigning different fields for the different answers, and setting up the form accordingly. Thank you all for your help though.

The locations are the possible answers to the question. It's like this: Q = At what location(s) are you taking courses? (please select all that apply) A = Oakland A = Saturday College A = Mt Lebo A = Monroeville

OK, I read up on it, and I don't think I'm finding what I need. It's telling me I need to analyze the table? I'm more than slightly confused. Let me tell you how the db is set up. I have 2 tables, one is the "master" table called tblSurvey. (in this table is a field called Location) The other...

Hi, this is my first post here. My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers. For instance, question 2 reads: "What location/time are you taking courses (select all that apply)" and the possible answers are...