Smart Filter For My Query

[alex]

Hi,

Can anyone tell me how do I do a filter under the query criteria with many
effective & expiration dates but only want to see the values that fall under
the period that I want. Below are to examples that would better explain what
I want to achieve. Please if anyone has any idea of how I can make this
happen let me know I would really appreciated. I have posted this question
twice already but the suggestions given are not working.

*The first response I got on my question someone told me to use: =
#1/1/1753# Or > #12/01/2009#

*The second response I got on my question someone else to me to use:
EFFECTIVE AFTER 12/01/09



Example# 1

EFFECTIVE 12/01/09 to 12/31/09

Effective Expiration Date
Date

1/1/08 1/1/1753=No Expiration (WANT TO SEE)
5/01/08 1/31/10 (WANT TO SEE)
1/1/10 2/28/10 (DO NOT WANT TO SEE)
3/1/10 1/1/1753=No Expiration (DO NOT WANT TO SEE)

Example# 2

EFFECTIVE 1/01/10 to 1/31/10


Effective Expiration Date
Date

12/01/09 12/31/09 (DO NOT WANT TO SEE)
5/01/08 1/31/10 (WANT TO SEE)
1/1/10 2/28/10 (WANT TO SEE)
3/1/10 Blank=No Expiration (DO NOT WANT TO SEE)

 

[KARL DEWEY]

If the date ranges must apply to both the effective & expiration dates then
put the same criteria on the same line under the fields. If you want it to
apply if either fall within the range then place the criteria on separate
lines under the fields.
For a date range use like this --
Between #lowest date# AND #highest date#
or

=#lowest date# AND <= #highest date#

You can have the query to promt like this --
Between [Enter start date] AND [Enter end date]

Make sure the format you enter the date is one that Access recognizes.