Creating a questionnaire database

[Tiffany]

I am trying to create a database that would include a form that is set up
like a questionnaire. The form has 15 questions (I've been using combo boxes)
and each can be answered with either "Met", "Not Met", or "N/A". I need to
take the responses and not only generate a report that displays the response
to each question, but groups the questions/responses together by answer.
I've tried creating tables and queries in every possible way I could think
of, but just cannot get the report to display the right data. Any help on how
to get this going would be appreciated!

 

[scubadiver]

What tables do you have and how are they related? I will tell you now a
survey database only needs three tables

respondent table
Resp_ID (PK)

question table
Q_ID (PK)

response table
resp_ID (FK)
Q_ID (FK)

The point being you append the questions to the responses table and each
question is a record.

 

[Douglas J. Steele]

For a properly designed survey database, see Duane Hookom's At Your Survey

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Tiffany]

I had two tables, tableQuestions and tableResponses. The fields in
tableQuestions were: nurseProvider, reviewedBy, reviewedDate, patientID, q1,
q2, q3, etc. (all the way through 15). Then I had "Met", "Not Met", and "N/A"
in tableResponses (N/A is a possible answer to select on the form, but
questions with that response will not be displayed on the report).

 

[Tiffany]

I think the link is outdated; there is no longer information there.

 

[Douglas J. Steele]

Works fine for me, but I know Roger was talking about some issues he's been
having with the links not working properly in certain cases.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and find Duane's
name at the top. Clicking on that should take you to a listing of all of his
samples (or you can just scroll down the page until you find his entries).
At Your Survey is the second entry in his section.

 

[Tiffany]

Thanks, it worked that time.
--
Tiffany Lynne

Works fine for me, but I know Roger was talking about some issues he's been
having with the links not working properly in certain cases.

Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp and find Duane's
name at the top. Clicking on that should take you to a listing of all of his
samples (or you can just scroll down the page until you find his entries).
At Your Survey is the second entry in his section.