Search results

YOU GUYS ARE GREAT !!! Renaming the module worked. I am checking the results right now but so far and I cannot find a wrong time calculation. I will check a couple more records. Thanks so much for your help !!! :D

Hi Willpower, Here we go. Attached is the DB with some test data and the function. Thanks in advance, Michael

Hi Willpower I'll got an error "Undefined function 'fnSLA' in expression". Any Idea ??? Thanks so much for you help in advance. Michael

Thanks. I will try and see if it does the job.

Hi Willpower, Maybe you can point out here the exact steps I have to follow (function) on how to get this done. The ideal would be a function to be used in an update statement to populate "SLA Response time" based on the dispatch date/time and Severity..... Thanks in advance, Michael

I know of this function, but it does not do the trick

Hi, I need some help with cut off time (off time) calculations in MS-Access. I have a database with dispatch dates for tickets. Based on the Severity there is a response time associated with it. Now, for Severity 3 tickets we have a response Time of 2 hrs. (Severity 4 = 24 hrs.) from Sunday...