In a query for my report, I am testing if a field contains a certain string, then if so, override the value to "Approved". I have tried several different variations, but it never seems to flag true.
I have also tried:
Neither seem to ever be true and return
Mfr: IIf(InStr(1,[OverrideType],"Over",1)>0,"Approved",[Manufacturer])
I have also tried:
Mfr: IIf([OverrideType] = "Override", "Approved", [Manufacturer])
Neither seem to ever be true and return
[Manufacturer]
even if [OverrideType]
is "Override".