Hello I am new to Access and have been struggling for the past few days with a query to call the data in one column that is within a data range.
I have written both a nested IIF statement and a SWITCH statement. However, when I run it, it looks like it's not allowing a space. Is there a way around this?
TAT Status: IIF([PO Line Creation Date] <[ Requisition Approval Date], ,(IIF([Working Days]<0, Pre-ReqApproval, IIF(AND( [Working Days]>=0,[Working Days]<=3), 0 to 3 Days, IIF(AND([Working Days]>=4, [Working Days]<=6), 4 to 6 Days, IIF(AND([Working Days]>=7, [Working Days]<=10), 7 to 10 Days, IIF([Working Days]>=11, Over 11 Days)))))))
TAT Status: Switch ([PO Line Creation Date]<[ Requisition Approval Date], “”,[Working Days]<0, “Pre-Req. Approval”, [Working Days]>=0 AND [Working Days]<=3, “0 to 3 Days”,[Working Days]>=4 AND [Working Days]<=6,”4 to 6 Days”,[Working Days]>=7 AND [Working Days]<=10,”7 to 10 Days”,[Working Days]>=11, “Over 11 Days”)
Any help would be GREATLY APPRECIATED!
I have written both a nested IIF statement and a SWITCH statement. However, when I run it, it looks like it's not allowing a space. Is there a way around this?
TAT Status: IIF([PO Line Creation Date] <[ Requisition Approval Date], ,(IIF([Working Days]<0, Pre-ReqApproval, IIF(AND( [Working Days]>=0,[Working Days]<=3), 0 to 3 Days, IIF(AND([Working Days]>=4, [Working Days]<=6), 4 to 6 Days, IIF(AND([Working Days]>=7, [Working Days]<=10), 7 to 10 Days, IIF([Working Days]>=11, Over 11 Days)))))))
TAT Status: Switch ([PO Line Creation Date]<[ Requisition Approval Date], “”,[Working Days]<0, “Pre-Req. Approval”, [Working Days]>=0 AND [Working Days]<=3, “0 to 3 Days”,[Working Days]>=4 AND [Working Days]<=6,”4 to 6 Days”,[Working Days]>=7 AND [Working Days]<=10,”7 to 10 Days”,[Working Days]>=11, “Over 11 Days”)
Any help would be GREATLY APPRECIATED!
