In my subform you can change employees time in to work and time out of work for each day. So when you change an employees time it recalculates the employees hours worked within the form. But if even one field is left blank within the record[Employee ID], The Hours Worked field will not show in data... PERIOD.
But like I said before, the form works fine IF the short time formated data is entered in Each and Every field.
Can someone please help me understand what I have done wrong here.
Is it possible to have [Monday In], but [Monday Out] is left blank? How do you want to do with the blank? Do you want to assign a default value?
Logically, all data should come in pair. Assuming that the "In" must have "Out" in the same day (if "In" is null, then the "Out" is null), you can just use:
Nz([Monday Out] - [Monday In], 0) + Nz([Tuesday Out] - [Tuesday In], 0) + ...