Ok, so I have a table that lists all possible questions. I then have a table of answers for those questions. Each user gets the entire list of questions in a continuous form. I would like to join the answers table to the questions table. Here is my join statement.
FROM tblQuestions LEFT JOIN tblAnswers ON (tblQuestions.[Question ID] = tblAnswers.[Question ID])
My problem is that if I then add
WHERE tblAnswers.[User] = [Forms]![frmSurvey]![User] OR tblAnswers.[User] Is Null
And this particular user hasn't answered the question yet, but another user has, the query will not display the question at all for that user.
I want to get something like this in datasheet view (this would be minus the WHERE clause)
This would allow User2 to answer the questionCode:Question ID Question Answer ID Question ID Answer User 1 Blah? 1 1 Blah. User1 1 Blah? {Null} 2 Blah2? 2 2 Blah. User1 2 Blah? {Null}
But I only get this
If I add the WHERE clause, I would get no results, but I want it to list all the questions anyway, regardless if it has been answered before.Code:Question ID Question Answer ID Question ID Answer User 1 Blah1? 1 1 Blah. User1 2 Blah2? 2 2 Blah. User1