Date ranges filtering

bimmer5

Registered User.
Local time
Today, 15:07
Joined
Apr 22, 2008
Messages
67
I need to filter two date ranges from the table. The table contains the date entries from Jan 01 2007 - Oct 24 2008. The requirement is to filter the following date ranges:

Jan 01 2007 to Oct 21 2007 and
Jan 01 2008 to Oct 21 2008

This needs to be done using the Design View and not the SQL view.
How to enter the proper criteria?
Please find the attached sample.
Thank you.
 

Attachments

In design view, put the second criteria on the second line. That creates an "OR" in SQL view.
 
Paul, thank you very much, I appreciate it.!
 

Users who are viewing this thread

Back
Top Bottom