Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about IIF in SQL query
I was trying to send a SQL query using ODBC to fill my worksheet with
some invoice information. In the Amount field I want it to be in negative if the doc type is RETURN. So I did: Select DOCNUM as Document, DOCDATE as DocDate, IIF(DOCTYPE="RET", -DOCAMT, DOCAMT) as Amount From TableName I was complaining about SQL syntax error. If I removed the IIF line it worked fine. Does SQL support IIF? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Query question | Excel Discussion (Misc queries) | |||
One Last Query Question | Excel Discussion (Misc queries) | |||
Web Query Question | New Users to Excel | |||
MS Query question | Excel Worksheet Functions | |||
Web Query Question | Excel Discussion (Misc queries) |