Forms and Queries

  • Thread starter Thread starter cackerman
  • Start date Start date
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.
 
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...;
 
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
 
Back
Top