Recent content by m1kegbrown

newbie right now the result is given from a pull down that selects from very good to very bad.(or as relevant to the question) this answer along with its key are stored in a table that references the usersid and the answer

I have two questions, and I am going mad trying to figure them out. I hope someone can at least give me some positive guidence into the resolution of at least one problem. Let me start by saying I have a questionaire database. It collects user information such as name and phone number, tests...

I am trying to create a report that looks at users responses to 8 questions, and returns all the users who selected positive answers to 5 or more questions. Each question usually consists of 5-6 answers and usually 2 of those are a positive result. Do I need to make +100 if statements to...

Does anyone have the code for, or know how to import a file that is tab delineated, not comma delineated?

linking table The problem is that one answer can be used by different questions. ie. how was the teachers method of teaching very good good neutral not good bad How did you do in this class very good good neutral not good bad But the...

I am trying to create aa questionaire where I do not have to enter in the questions and answers statically. I have made table of questions and a table of answers and a joining table that has the id from each of the preceeding tables. The problem is every time I make the table I never get the...

I have a questionaire with 8 questions. On my form there is a series of 5 possible answers. The answers are ratings from very good, to very bad. I want to produce a report that shows all the people who answered very good or good to at least 5 of the 8 questions. How do I do this? DO I just make...

History: We are using a form to associate a specific answer (given from an answer table) to a specific question (given from a question table) for a specific survey (given from a survey table) for a specific participant (given from a participant table). However each survey is not exclusive to...

History: I am converting testing data from a paper format into a DB ( using access). I need to have an easy to use UI. Most of the tables have been finished and the relation diagram is complete. However I am having problems getting the UI to populate and manipulate some of the data. Problem...

the join tables are used because each test has an undefined number of questions that is pulls from a table based on its ID and each question has an undefined number of answers associated to it. that are assigned by an id. the problem is for each participant who takes the test they must be...

I have 3 tables a questions table (QID, question) Answer table (AID) and a join table (JID, QID, AID) I can't figure out how to make a form that lists each question and next to it a combo box to select the appropriate answers I can make a query that produces all the questions (which are...