Exclude Date Range

[Guest]

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

 

[Guest]

Try

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