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.
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.