_____
De : [email protected] [mailto:[EMAIL PROTECTED] De la part
de John Viescas
Envoyé : lundi 17 avril 2006 16:44
À : [email protected]
Cc : [email protected]
Objet : [ms_access] RE: [MS_AccessPros] finding blank entries
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/ <http://www.viescas.com/>
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/ <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
* Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
