ACCESS FEED: Re: [MS_AccessPros] Need help with query

Selasa, 23 Februari 2016

Re: [MS_AccessPros] Need help with query

Thanks so much, John! I'll give it a try and get back with questions!

On Tue, Feb 23, 2016 at 3:52 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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
http://www.viescas.com/
(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