V Voyager Registered User. Local time Today, 04:38 Joined Sep 7, 2017 Messages 95 Feb 4, 2018 #1 Hi team, Kindly check the attachment I have a form with few calculated fields (i.e) Total of On job row will be start time - end time for all the rows it work well but I am unable to cumulate the total of all the three totals could you assist? Attachments Test.accdb Test.accdb 500 KB · Views: 76
Hi team, Kindly check the attachment I have a form with few calculated fields (i.e) Total of On job row will be start time - end time for all the rows it work well but I am unable to cumulate the total of all the three totals could you assist?
bob fitz AWF VIP Local time Today, 00:08 Joined May 23, 2011 Messages 4,807 Feb 4, 2018 #2 Not sure that I understand what you want but perhaps this helps: Attachments Test (1).accdb Test (1).accdb 500 KB · Views: 69
V Voyager Registered User. Local time Today, 04:38 Joined Sep 7, 2017 Messages 95 Feb 4, 2018 #3 Many Thanks Bob, That worked like a breeze you have sorted out my head ache. Though I made a small change to the nz function from - I have changed it to + =Nz([text4],0)+Nz([text14],0)+Nz([text21],0)
Many Thanks Bob, That worked like a breeze you have sorted out my head ache. Though I made a small change to the nz function from - I have changed it to + =Nz([text4],0)+Nz([text14],0)+Nz([text21],0)