Hi all
I have a access table which I hopefully have correctly attached a snapshot of
here
The dates will always be consecutive and span from current date - 13 to current date +13
I am looking for something that, in a report, will sum consecutive days worked only, regardless of the year week no. So something that will sum the hours field in rows 2 & 3 then sum the hours field in rows 6 & 7 etc. Is this possible? Any help would be appreciated.
I have a access table which I hopefully have correctly attached a snapshot of
here
The dates will always be consecutive and span from current date - 13 to current date +13
I am looking for something that, in a report, will sum consecutive days worked only, regardless of the year week no. So something that will sum the hours field in rows 2 & 3 then sum the hours field in rows 6 & 7 etc. Is this possible? Any help would be appreciated.