Search results

would like to make an expression in an Access report, that if the field contains a space and the word "is" it should return one text and if it doesn't contain it should return another text. I'm using =iif(instr(" is",[field_name])=0,"OK","not OK") and it is not working it is always returning...