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:
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 2.
