I have the following fields (expressions) in my query based on certain fields from my table
Expr3: IIf((([Expr1]<=[Expr4]) And ([Expr4]<=[Expr2])),"Yes","No")
Run just like that I get the desired results i.e. I am getting those records which conform to Yes and those to No.
However when I further filter the query by entering “Yes” in the criteria of the field in my effort to try and select only those records which result in “Yes” I get asked to enter the data for Expr1, then Expr4 and then Expr2.
Grateful for ideas why this is happening.