Selasa, 23 Februari 2016

Re: [MS_AccessPros] Need help with query

 

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:

Poskan Komentar