Criteria filter within query

[stevo]

I have designed a query with an expression field shown below. I am trying to filter based on the text result of the expression, but it won't let me do this.
I'm obviously missing something - any help would be greatly appreciated.

The expression is:-

exp5: IIf(Date()>[expr4],"Cal within Month","Calibration OK")

The criteria filter is:-

= "Cal within month"

expr4 refered to above is an expression field returning a date.

 

[MStef]

Look at "DemoDateQueryA2002.mdb" (attachment, zip).
Table1, Query1.

 

[stevo]

Thanks for your help MStef, but the date reference I'm using is from an expression: - expr4: DateAdd("m",12,[FDate]).

This seems to cause the problem; when refering to a simple date field it's ok.

 

[MStef]

OK, look at "Demo" a new one.
Look at query1.

 

[stevo]

Thanks very much MStef - that does the trick.