If I have a date field, how can I "phrase" a query to give me, say, all of the records between 01/01/2009 and 01/01/2013?  
Also, if I run a delete query, and come up with 100 dupes, must I delete them one at a time, or is there a way to go through the list and highlight all of the ones to be deleted?
Thanks.

---

Reply from Richard Rost:

David, for your first question, use the BETWEEN keyword, such as:

BETWEEN #1/1/09# AND #1/1/13#

This is covered in Access Beginner 3 (the next class).

A DELETE QUERY will wipe out the records without giving you a chance to review them IF you run the query. If you want to be able to go through and pick them one at a time, then you'll have to just set up your criteria in a normal query and scroll through the list. There is also a FIND DUPLICATES query, but I'm not a big fan of it.