Invalid nProcedure Call

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top