I understand that the title may not be too clear, I couldn't find a better one.
This is for a system that tracks time entries from employees. The table has these columns:
- Hours worked
For the report, the user enters two dates that are automatically adjusted for a Sunday as the beginning and a Saturday for the end. The period may span one more weeks.
What I need to do is for each week in the period, get for each customer the number of hours worked for a specific project. And this is where my head bangs on the desk. I don't see how I can do simple calculations using calculated fields or summary fields on the table.
I don't see how I can realize that report without generating a temporary table. This is a way I don't like to go. Which way is the best to realize that report ? I hope I am clear enough.
I just had a thought: I could add a calculated field which would be set to the Sunday a specific entry is attached, this way defining a specific Week. Then the report would get sub-summary totals per Week and per customer. Could that work ?