The questions are in a table Questions with following fields:
Respondents' answers are in a table Respondents with the following fields:
Ans2 LU (etc thru 18 answers)
Answers 1-12 are linked to a 4 part Likert LookUp table
Answer 13 is linked to a 3 part LookUp table
Answers 14-18 are open ended
This arrangement is fine for the data-entry form, but I'm having trouble getting a relationship to the questions and building a crosstab query.
I think my db design is flawed.