Forms and Queries

C

cackerman

I have created a form containing a list of questions that require only
Yes, No or N/A responses. I now want to query the results to display
each question with total Yes, No and N/A responses given for each
question. The query will not summarize the data the way I would like.
It contains numerous duplicates and is very difficult to follow. Any
suggestions?? I have a feeling I've created the tables incorrectly but
have tried every other way with no results.
 
D

Duane Hookom

I expect you have created a wide table structure rather than normalized. If
your tables were like At Your Survey found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane, the
query might be simple.

If your table is wide, you can use a union query to normalize it. Something
like:

SELECT ID, Q1 as Answer, "Q1" as Question
FROM tblTooWide
UNION ALL
SELECT ID, Q2, "Q2"
FROM tblTooWide
UNION ALL
SELECT ID, Q3, "Q3"
FROM tblTooWide
UNION ALL
....etc...;
 
J

John Welch

It's very hard to tell what you've done incorrectly because you don't give
any details of what you've done. But it sounds like reading about crosstab
queries might help you out.
-John
 
Top