Exclude Date Range

M

Mary Z

I have started a query to look at active records in a database with a Begin
Date field and an End Date field (those with a Null End Date) and want to
exclude Begin Date values, i.e. 07/01/06-07/10/06. How do I exclude them?

Thank you.
Mary
 
O

Ofer Cohen

Try

Select * From TableNAme Where
[Begin Date] < #07/01/06# And [Begin Date] > #07/10/06#
 
Top