Search results

Dear Friends, I have the below code which I get from this valuable forum, the below code is returning the total time time for each task within my department. I want to understand why we use MOD function in this. I read in help and browse it says this will divide 2 numbers. I am...

Dear Sneuberg, I have slightly amended the code: 1. amended the start and end time 2. amended the total time of the day which is 435 3. amended the form through which this code will be called But unfortunately, the result is not appearing in the form. attaching word file...

Dear Sneuberg, I will try and let you know. many thanks for your prompt and excellent support. I owe you and arnelgp a dinner

Friends, I believe there is some issue with the code, I have added request date Wednesday (02-Dec-15 10:13:00 AM) and response date Thursday (03-Dec-15 12:34:00 PM). if I calculate manually, the total time should be 10:34 or 634 minutes. However, in my result it is showing 576. please...

Friends - just testing the above scenario, I have put date request date as Friday (15-Jan-16 10:13:00 AM) and response date as Sunday (17-Jan-16 11:26:00 AM). Since we don't work on Friday and Saturday, SLA should start counting Sunday 07:15 which means the total time taken should be 04:11 or...

Bro Arnelgp and Sneuberg, million million thanks for your expert advice.... it worked. I am really thankful to you guys.

I am a new user, I have followed from this forum and manage to calculate turn around time for tasks within department. We have weekend here on Friday and Saturday, I believe the below code is for Saturday and Sunday... can someone please help me to fix this issue to exclude Friday and...

Dear Expert Friends, I am a new user, I have followed from this forum and manage to calculate turn around time for tasks within department. We have weekend here on Friday and Saturday, I believe the below code is for Saturday and Sunday... can someone please help me to fix this issue...

that's lovely, how silly I am :) I was using sum function. thank you very much dear.

Dear Expert Friends, since I am new, may be this question is really bad. but I couldn't figure out how to do that. I have report based on query and each row has name of employees and 2 columns SLA met or Not Met. I want total against each employee. please see screenshot. many...

Dear Arnelgp, I am really grateful to you for your excellent support, wish I can offer you a dinner as a thanks. Now, based on amendments in the query the report is showing correctly (see the attached report screenshot). Many thanks once again Brother, I may bother you again :) if need...

Not mandatory to use query if report meets my requirement .. I will be more than happy. Actually left my work and couldn't open database on Macbook... Will check tomorrow morningI am thankful for your help

Dear Arnelgp, I have attached the sample database for your support. I need a report based on query "Individual_Completed_Task_Report" the report is first group by Task_Type then Allocated to, under each staff name I want to see how many tasks SLA were met and how many were not...

Dear I want all the staff name to appear in this report.. so for [staff name], what I should put here. I am so sorry I am bit new that's why bother a lot.

Dear Friends, First of all thank you for your usual help on this forum. I have a question on report today, I have a field in table SLA_Met (text data type). Each staff may meet SLA or Not for a particular task, therefore I need to show something like this but don't know how to do that...

Hi Galaxiom - Dear If I am changing data type of TotalTimeTake it is no longer calculating. Do you suggest I change the data type of agreed SLA to text so that both will be same and then calculation should work

see the screenshot, what I need when I click on update record. it should check the value in Agreed SLA (which is calculated automatically) not saving in database. then I have Total Time Taken (it is saved in database). I want to compare these both values and show in SLA Met Box whether SLA Met...

I have also tested by just showing a message box to see the value example below MsgBox "Value " & Me.SLA_Count.Value MsgBox "Value " & Me.Total_Time_Taken.Value it was showing the correct value, however, when I am comparing it is not showing correctly the difference such as SLA Met...

Dear All, I have 2 text boxes Agreed SLA which is automatically computed and not getting stored in database and another box total time which is saving in database. I am trying to compare both and see whether SLA is met or not with the below code but everytime it's showing SLA Not Met...

Man I am really grateful to you for your help on this. I may bother you again for some other things since I am new in using access but I am trying my best.