Thank you everyone for your replies to this thread. I finally got it to work. I really really appreciate the time that everyone put in to answer this question. I didn't get a chance to work on my access again till today and I re-read all of the responses and got it work.

Thank you for the hint of the In() clause. Since dates are pretty squirrely on Access I changed the field to "short text" This solved my problem in another query I was doing a while ago. Anyway here is my script
When I ran the query I got the message "At most one record can be returned with this subquery"...

Hello,
I am rather new to Access and I have a question. I would like to run a query that gives me the needed information only on specific dates. The database is composed of oil well data on a daily basis. What I need to do is to run a report for multiple dates. I need to cherry pick those dates. I don't need a range of dates. I need specific discrete dates. e.g. 5/29/2012 6/14/2012 7/2/2012 8/14/2012. A Range of dates looks easy...