searching between dates

[He cries for help]

I have a query that I need a formula that will allow me to search for a date
i.e. all dates between 03-01-08 and 03-23-08. This will allow me to search
for all items in ny
data base that will become date sensiitive during a date span.

 

[John W. Vinson]

I have a query that I need a formula that will allow me to search for a date
i.e. all dates between 03-01-08 and 03-23-08. This will allow me to search
for all items in ny
data base that will become date sensiitive during a date span.

Use a criterion on the date field of

= CDate([Enter start date:]) AND < DateAdd("d", 1, CDate([Enter end date:]))

The DateAdd stuff is to cover the case that you may have a time portion in
your datefield.