QRY for Everything open in a certain time period

[Guest]

I am trying to write a query that will capture everything within a certain
time frame. The two date fields that I have are an open date and a close
date located in the same table. I am trying to capture everything that was
open at any point between two dates.

For example, Order A came in on 10/2/04 and was closed 10/10/04 (all orders
still open in the specified time). Order B came in on 10/7/04 and was closed
10/25/04 (all orders recived during the specified time). I want to know all
open orders between 10/3 thru 10/15/04. So I want to make sure that my query
captures both of these orders and I want to be able to make sure any orders
opened past 10/15/04 are not included.

Any help will be appreciated.

 

[Guest]

in your query, in the date field enter this criteria

=#10/3/04# and < #10/15/043 or
=[enter a start date] and < [enter an end date]

I prefer the latter because it is more versital. i don't
have to retype the whole criteria, just enter the dates.