James-
Do this in two steps. First, find the Full Address of all early voters:
qryEarlyAddress:
SELECT Voters.[Full Address]
FROM [Early Vote] INNER JOIN Voters
ON [Early Vote].VoterID = Voters.VoterID
Now use that to find your solution:
SELECT *
FROM Voters LEFT JOIN qryEarlyAddress
ON Voters.[Full Address] = qryEarlyAddress.[Full Address]
WHERE qryEarlyAddress.[Full Address] IS NULL;
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 23, 2016, at 10:42 PM, James McAlister kc5qeg@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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.
James
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar