I have the little formula you see below... when I press enter access converts to what you see below that... any ideas as to why???
Mine
STAT: IIf([Status]=00,ACT,IIf([Status]=03,ALT,IIf([Status]=01,ALT,IIf([Status]=02,ALT,IIf([Status]=08,ALT,IIf([Status]=09,ALT,IIf([Status]=06,DOR,IIf([Status]=07,DOR,IIf([Status]=10,DOR,)))))))))
Access
STAT: IIf([Status]=00,[ACT],IIf([Status]=[03],[ALT],IIf([Status]=[01],[ALT],IIf([Status]=[02],[ALT],IIf([Status]=[08],[ALT],IIf([Status]=[09],[ALT],IIf([Status]=[06],[DOR],IIf([Status]=[07],[DOR],IIf([Status]=[10],[DOR],[])))))))))
Bookmarks