query help

[sadie]

I have a database with election data and each time a person votes it is a new record (I didn't create the database)
How can I query it to find out who voted in 2004 but not in 2002 etc.
I'm using access 2000
Thanks

 

[FoFa]

SELECT query is what you need. I would try the query wizard and see if it will walk you through the process. But basically you will need a criteria of VotingDate BETWEEN 01/01/2004 AND 12/1/2004 or something like that to do date selection.

 

[sadie]

how would I write voting date in 2002 and not in 2004

 

[wardster]

Sadie - there is a thread further down the list that sounds like just what you need:

http://www.access-programmers.co.uk/forums/showthread.php?t=112195

a query to find matched and non matched records

Ian

 

[sadie]

query

thanks so much...I will try it