Create a new summary field for hrs total, create a layout with a trailing sub-summary part for employees – bút no body part (since you don't need to see the individual functions). Define a page break after each occurrence of Employee. Find the desired date range, sort by Date and Employee. The last bit is crucial: if you don't sort by the field(s) you use as break fields, there's no summary. Have a look into the attached file to see how this works.
The placement of the fields is a bit tricky; if you put the date in its own subsummary part, and you have entries for the same employee on two or more following days without another employee in between, then the date field content gets "summarized away" for all days after the first for that employee; that's why I put it into the employee sub-summary and did without the date part.
btw, the summary works live; if you have it open in Browse mode (as opposed to Preview mode, which gives you one summary at a time, as per the page break rule), open a new window, start entering new entries and watch FileMaker creating new summary lines or updating existing ones. Awesome!
Summary_eos.fp7.zip 7.0 K
Thanks for for your help and example,
This report get me very close to where I need to be,
It is gives me a summary of all employees by date in date order and then totals all their hours for that day.
What I need is to just have one emplyee per page per date range.
Thanks again for all the help.
It sounds like you need to switch around the sort order. Do exactly as suggested by erolst, except sort by employee first, then date. Then as mentioned by erolst, define a page break for every occurrence of employee. I personally prefer to use leading subsummary parts more often... it looks more like a heading, with all related information below it.