Query Error Msg "Too Complex"

[1andyw]

My input form asks four questions with a value of 1 to 5 for each question.
I "count" the values using "count" and "where"; using a separate query for
each value for each question, a total of 20 short queries. I attempt to
group the 20 queries into another select query and include information
from the original table regarding customer ID, address, etc. I do this
to prepare a report. However, for the select query, access returns an
error box "query is to complex".
How do I know what level of complexity to OK and what is "too complex"?

 

[Jack Cowley]

It sounds like your data is not normalized. If you want the count of '1' answers and the count of '2' answers, etc. it should not take 20 queries.

tlbRespondents
RespondentID (PK and autonumber)
LastName
FirstName

tblQuestions
QuestionID (PK and autonumber)
RespondentID (FK)
Question

tblAnswers
AnswersID (PK and autonumber)
QuestionID (FK)
Answer

hth,
Jack