gdunn59
asked on
MS Access Query - Nested IIF Statement isn't working
I have a MS Access Query that contains a Nested IIF Statement, but it doesn't appear to be working with the 2nd IIF Statement.
Here is the syntax I have:
Month3: IIf([thedate]>#10/1/2013#, UCase(Mont hName([the month],Tru e)) & "_2014_AEP",IIf([thedate]> =#10/1/201 4#,UCase(M onthName([ themonth], True)) & "_2014_2015_AEP",""))
What am I doing wrong?
Thanks,
gdunn59
Here is the syntax I have:
Month3: IIf([thedate]>#10/1/2013#,
What am I doing wrong?
Thanks,
gdunn59
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked great:
Month3: IIf([thedate]>=#10/1/2014#
Thanks,
gdunn59