Invalid nProcedure Call

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weird Query Possibility 1
Calling Parameterized Query Using SQL Syntax 3
IIF Error: invalid syntax, may have entered a comma w/o preceding 1
Nested If conversion to Select case 5
access 2003/2007 - problems with unwanted pipe character 0
Query design view - commas being changed to pipe characters 4
update query ODBC--call failed 3
Translate if statement in query 1

Top