brosenfelt
Registered User.
- Local time
- Yesterday, 16:44
- Joined
- Aug 13, 2015
- Messages
- 36
Hello,
I'm using an IIF statement to display the results of another expression I've created in the query (i.e. if one of them is blank, select the other). I'm getting a syntax error when running the query:
Any suggestions?
Thank you!
I'm using an IIF statement to display the results of another expression I've created in the query (i.e. if one of them is blank, select the other). I'm getting a syntax error when running the query:
Code:
SELECT [Credit Portfolio].[Credit Specialit Assigned], [Credit Portfolio].Disposition.Value, Sum([Credit Portfolio].[Principal Outstanding]) AS [SumOfPrincipal Outstanding], Switch([Credit Portfolio]![Exp/Mat Date]<Now(),"Past Due",[Credit Portfolio]![Exp/Mat Date]>Now(),"Future",IsNull([Credit Portfolio]![Credit Rev Date]),"N/A") AS [Status - Hard Mat], Switch([Credit Portfolio]![Credit Rev Date]<Now(),"Past Due",[Credit Portfolio]![Credit Rev Date]>Now(),"Future",IsNull([Credit Portfolio]![Exp/Mat Date]),"N/A") AS [Status - Cred Rev], IIf([Status - Hard Mat]="",[Status - Cred Rev],[Status - Hard Mat]) AS Expr1
FROM [Credit Portfolio]
GROUP BY [Credit Portfolio].[Credit Specialit Assigned], [Credit Portfolio].Disposition.Value;
Any suggestions?
Thank you!