Search results

  1. M

    access rookie in need of some help

    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...
  2. M

    newbie in search of help

    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...
  3. M

    import tab delineated

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

    creating a form with results from 2 seperate queries

    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...
  5. M

    producing a report with tons of if else

    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...
  6. M

    query problems

    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...
  7. M

    query

    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...
  8. M

    form to load a series of questions and answers

    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...
Back
Top Bottom