Bruce- Use an outer join from questions to responses and test for Null entries. Something like:
SELECT Questions.QuestionID, Questions.Description FROM Questions LEFT JOIN Responses ON Questions.QuestionID = Responses.QuestionID WHERE Responses.QuestionID IS NULL If you need to find out what questions were not answered by each person, it gets a bit more complicated. I assume you have tables like: Questions: QuestionID, Description, etc. Persons: PersonID, PersonName, etc. Responses: QuestionID, PersonID, Answer First, create a query that returns all possible people and questions: qryAllPersonsQuestions: SELECT Questions.QuestionID, Questions.Description, Persons.PersonID, Persons.PersonName FROM Questions, Persons Now find out which ones weren't answered: SELECT qryAllPersonsQuestions.* FROM qryAllPersonsQuestions LEFT JOIN Responses ON qryAllPersonsQuestions.QuestionID = Responses.QuestionID AND qryAllPersonsQuestions.PersonID = Responses.PersonID WHERE Responses.QuestionID IS NULL John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Sent: Sunday, April 16, 2006 11:45 AM To: [email protected] Subject: [MS_AccessPros] finding blank entries Hi I have several tables that are used for data entry. I wish to check to see if any entries are missing(for example someone failed to answer a question). Can someone recommend a good way to go about this? I intend to take this data and create a report that shows missing entries for each subject. Many thanks Bruce Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
