Invalid nProcedure Call

S

Shytown_Turk

Hello All,

I am trying to create a nested IIf statement in an Access 2007 query and
continue to recieve an invalid procedure error. When I seperate the
statements it works without a hitch. Any help would be greatly appreciated.
 
S

Shytown_Turk

Figured it out after a good nights sleep...

DateExp: Trim(IIf(InStr(1,Trim([secdesc]![Description_2]),"DUE
PERP")<>0,#1/1/2099#,IIf(InStr(1,Trim([secdesc]![Description_2]),"DUE")<>0,Right(Trim([secdesc]![Description_2]),Len(Trim([secdesc]![Description_2]))-InStr(1,Trim([secdesc]![Description_2]),"DUE")-2))))

Thanks
 
Top