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 VotersON [Early Vote].VoterID = Voters.VoterIDNow use that to find your solution:SELECT *FROM Voters LEFT JOIN qryEarlyAddressON Voters.[Full Address] = qryEarlyAddress.[Full Address]WHERE qryEarlyAddress.[Full Address] IS NULL;John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Feb 23, 2016, at 10:42 PM, James McAlister firstname.lastname@example.org [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 earlyVoters -- personal data (VoterID, Full Name, Full Address, etc.) for all votersBasically 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: James McAlister <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|