Times totals

[REDaughdril]

I have a report based on a query that has [StartTime] and [EndTime]. I have a exp1 in my query ([EndTime]- [StartTime] that gives me my time worked for that entry. What I need, is that my report is divided by weeks from the date field and I need a total time “worked” by week and a grand total “worked” at the end of the report. Every thing I have done in the date footer and report footer comes out strange or not at all. Thanks for the help.

 

[WayneRyan]

RE,

You can use the DatePart function to get the week that the
labor happened in. You can use it for grouping purposes and
sum up the "exp1" that has the times worked.

Wayne