I am continuing to write sql for my database and have encountered another question.
This is what I have:
FRT Due: IIf([DATE_ESCALATED]<=[DES
]),IIF( [DATE_ESCALATED] > [DUE_SCHED_DATE] ,DateAdd("H",3, [DATE_ESCALATED] ), [DUE_SCHED_DATE]
This is what the excel looks like and it works =IF(F5<=H5,H5,(IF(F5>G5,F5
+3,G5))), but I want this to work in an access query.
I have attache a sample of the excel book below.