I am trying to paste this formula into one of my queries, but I get the "the text is too long to be edited" when I paste the formula into the designated field. Is there anyway to get this paste without getting the error?
Access experience level = medium.
CurrentPhaseMetrics: IIf([CurrentPhase]="Phase 1",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 2",IIf([NumDaysInPhase]>35,"RED",IIf([NumDaysInPhase]>25,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 3",IIf([NumDaysInPhase]>25,"RED",IIf([NumDaysInPhase]>20,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 3a",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 5",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 4",IIf([NumDaysInPhase]>3,"RED",IIf([NumDaysInPhase]>1,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6a",IIf([NumDaysInPhase]>7,"RED",IIf([NumDaysInPhase]>5,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6b",IIf([NumDaysInPhase]>90,"RED",IIf([NumDaysInPhase]>45,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 7",IIf([NumDaysInPhase]>2,"RED",IIf([NumDaysInPhase]>1,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 8",IIf([NumDaysInPhase]>30,"RED",IIf([NumDaysInPhase]>20,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phases Complete","Completed","Closed"))))))))))))))))))))
Access experience level = medium.
CurrentPhaseMetrics: IIf([CurrentPhase]="Phase 1",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 2",IIf([NumDaysInPhase]>35,"RED",IIf([NumDaysInPhase]>25,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 3",IIf([NumDaysInPhase]>25,"RED",IIf([NumDaysInPhase]>20,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 3a",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 5",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 4",IIf([NumDaysInPhase]>3,"RED",IIf([NumDaysInPhase]>1,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6",IIf([NumDaysInPhase]>5,"RED",IIf([NumDaysInPhase]>3,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6a",IIf([NumDaysInPhase]>7,"RED",IIf([NumDaysInPhase]>5,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 6b",IIf([NumDaysInPhase]>90,"RED",IIf([NumDaysInPhase]>45,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 7",IIf([NumDaysInPhase]>2,"RED",IIf([NumDaysInPhase]>1,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phase 8",IIf([NumDaysInPhase]>30,"RED",IIf([NumDaysInPhase]>20,"YELLOW","GREEN")),(IIf([CurrentPhase]="Phases Complete","Completed","Closed"))))))))))))))))))))