Hi again. I have used this site on several occassions to solve seemingly impossible results - so I am putting my lack of IIF knowledge out here hoping I will get to stamp this one "SOLVED".
Here is my dilema:
I need to create a column that will let me know what quarter the work was accomplished during the fiscal year.
Here is my query:
Reporting Quarter: IIf([Effective Date]=">#10/01/2011# and <#12/31/2011#","FY 12 Quarter 1",IIf([Effective Date]=">#01/01/2012# and <#03/31/2012#","FY 12 Quarter 2",IIf([Effective Date]=">#04/01/2012# and <#06/30/2012#","FY 12 Quarter 3",IIf([Effective Date]=">#07/01/2012# and <#09/30/2012#","FY 12 Quarter 4","Not Yet"))))
All the results = "Not Yet"
HELP!