I can send you the sample if you give me your email address

Send me your email address and i can send you the sample I created.

NICE!

Not sure I fully follow but wouldnt it be easier to just add a row for the next set of technicians and then get a total?

And you want to calculate for each day? Day 1 totalDay 2 total etc?How will you do this in the form?

I would have to think on it. The issue really will be how is the form set up. For example if the form is only used for one day regardless of how many techs you send out then it becomes easy but if the form captures techs over a number of days, it becomes a bit more complex. In your example (see belo...

I guess I understand that. You would need to loop through the dates and get all the technicians for a date.

I see a couple things that are interesting/concerning. what do you qualify as a day? I see only 3 hours per technician. Is that considered a day? How are you creating the form inputs? is it in a table? Will only one day be used per form or table? The way I would approach it is to loop through the da...

Unfortunately if you cannot share the file I am not sure how I can help you.

If you'd like to send me the file I will be happy to look at it. my email is mousland@gmail.com