criteria show only with dates

[raffi]

hello i have a query with a date field and item field

in the design view of the query, within the criteria of the date field, i have the following, <> date()



it is filtering out the blanks, which is exactly what i want, but unfortunately, it is also filtering out the current date,

i would like to filter out the blanks in the query only, not the current date.

if theres an alternative to , <> date() which only filters out the blanks and not the current date, would be much appreciated

maybe if i can set formula which says, show me all dates from 2007 until 2050, then i would be an old man but however the problem would be solved since it would show the current date and no item expiry date exceeds 2050, and the blanks will be filtered out


thanks in advance

[pbaldy]

Try

Is Not Null

in the criteria.