Any help on why this nested IIF statement isn't working properly? There aren't any errors. It just returns "Processing" for every field. I've checked spelling, etc. but no luck.
Code:
Function: IIf([dbo_flat_wo]![status]="File Prep" Or "File Process" Or "File Received" Or "File Rev Miss/I" Or "File Setup" Or "Package Sent" Or "Recommendation" Or "Rev Miss/Incmpl","Processing",IIf([dbo_flat_wo]![status]="Complet Pkg MOD" Or "Completing File" Or "File to U/W or" Or "File to UW/INV" Or "Negotiator Revw","Underwriting",IIf([dbo_flat_wo]![status]="Approval" Or "Approved" Or "Final Payments" Or "Stip Requiremnt","Approved",IIf([dbo_flat_wo]![status]="Docs to Borrow" Or "Docs to Borrowr" Or "Mod Sent To Mtr","Closing",IIf([dbo_flat_wo]![status]="Admin Pending" Or "Ad-Pending" Or "Docs Returned" Or "Pend Inv Req" Or "Receipt Of Mod" Or "Receipt Mod","Booking","N/A")))))