SELECT......., IIf([Days Opened]>[SLA Agreement],"Yes","No") AS [Has Meet SLA]
Specifically my issue is with:
IIf([Days Opened]>[SLA Agreement],"Yes","No") AS [Has Meet SLA]
I am getting an 'out of disk space in temp location error' I know I am not out of disk space. Does it matter if there are no values in some of the 'Days Opened' or 'SLA Agreement' fields? Any assitance getting this working while allowing empty field values would be great. NOTE they are both number data types.
Understadnt his should have been a noew topic, sorry bout that.
I placed 'Public' in there however same result. Here is my full query:
SELECT Format([DateTime],"dd/mm/yyyy") AS [Date Time], TBL_Support_Call.Ref, TBL_Support_Call.[Issue Summary], TBL_Support_Call.Comments, TBL_FollowUp.Comments AS [Follow up Comments], TBL_Support_Call.[User Name], TBL_Support_Call.BU, TBL_Support_Call.Issue, TBL_Support_Call.Link, TBL_Support_Call.Category, TBL_Support_Call.[Functional Area], TBL_Support_Call.[Contact Source], TBL_Support_Call.Status, Format([mmmm.maxdate],"dd/mm/yyyy") AS [Closed Date], TBL_Support_Call.[Logged BY], TBL_Support_Call.Owner, CalcWorkdays([DateTime],[mmmm.maxdate]) AS [Week Days Opened], SWITCH
[Week Days Opened] <= TBL_SLA_Activity.[Number of Days] , 'YES',
[Week Days Opened] > TBL_SLA_Activity.[Number of Days] , 'NO',
) AS [Has Meet SLA]
FROM ((TBL_Support_Call LEFT JOIN TBL_FollowUp ON TBL_FollowUp.[Original Call Ref] = TBL_Support_Call.Ref) LEFT JOIN TBL_SLA_Activity ON TBL_SLA_Activity.ID = TBL_Support_Call.SLA) LEFT JOIN [SELECT TBL_Call_Staus_History.refID
, MAX(TBL_Call_Staus_History.CloseDate) AS maxdate
BY refID ]. AS mmmm ON mmmm.refID = TBL_Support_Call.Ref
WHERE TBL_Support_Call.Status<> 'Delete'
ORDER BY TBL_Support_Call.Ref DESC;
NOTE if I remove 'CalcWorkdays([DateTime],[mmmm.maxdate]) AS [Week Days Opened' the query runs fine
Would be so useful to get working.