I Have a form on which Pending cases will be shown from a particular excel sheet.


I have already calculated the Elapsed time in the query and I need to calculate Due After field:-

Due After would be :- Opened Time +SLA(usually 1 day which will be selected from combobox)+Time Extension

Can someone help me how to calculate Due After field.

I have attempted this one but this doesnt work:-

In Query design view:-

Due After1=Format(Issues.[Opened Time]+1+Issues.[Time Extension])

In the above field Time Extension is a Number of hours the time will be extended. SLA for 24 hours(1 day added).



Any Help would be appreciated.

Cheerz