Each line as shown in figure, it is necessary to calculate two overlapping period days, if the date is empty, can be considered to be full time or a half time,

O great god with ACCESS generator under the advice how to lose function

CodePudding user response:

EXCEL directly inside the
MIN (deadline. A, B) the deadline of - MAX (start date. A, B) start date
Can do it, get a negative number means no overlap, but don't know how to use the function in the ACCESS