I need help in structuring a query. There are two tables involved:
Early Vote -- lists the VoterID of each person who has voted early
Voters -- personal data (VoterID, Full Name, Full Address, etc.) for all voters
Basically I need is a query to return Full Name and Full Address for all individuals in Voters EXCLUDING 1) all individuals who have voted early and 2) any other individuals with the same Full Address as an early voter. In other words, I want to exclude everyone at any address where at least one person has voted early.
I hope this makes sense--and thanks for the help!! I'm using Access 2010.
Posted by: James McAlister <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|