Cannot apply filter?

[SteveE]

I have a query where on an IIF result a field is displayed or an "OK"

I have an imported field of 6 chrs where I only want the left 5 so I use
Loc:=Left([Location],5) ,

I then compare the result in, MoveTo: to another fixed field [PreferLoc]

MoveTo: IIf([Loc]=[PreferLoc],"OK",[PreferLoc])

I wish to citeria out all the "OK" values so I have <>"OK" in the critria section but when I try to run the query I am presented with a selection box asking for Loc
This Query feeds a report so I set the filter to yes in the report properties and use [MoveTo]<>"OK" as the filter and this works great until I close and reopen the app where the filter has gone ?
Can anyone advise where I am going wrong with my query and or my report ?

thanks in advance
S

 

[neileg]

Do it all in one go:

MoveTo: IIf(Left([Location],5)=[PreferLoc],"OK",[PreferLoc])

 

[SteveE]

Filter

Thanks Neil works fine you the man!

Steve