echidna1000
New member
- Local time
- Today, 14:40
- Joined
- Sep 7, 2017
- Messages
- 3
Hello everyone, I've been tearing my hair out over this report.
The main table I use is a Timesheet, with columns like 'Start Date' and 'End Date'. I calculate the 'Duration' using DateDiff(). There are also Charge Rates, linked to the Grade of the person recording the time. They can be either Partner/Office Holder, Manager or Assistant/Support. Finally, there is SIP Field, which breaks down the kinds of tasks recorded, e.g. dealing with creditors, trading, realisation of assets, etc.
The Report needs to present the following things for a particular Case over a particular Date Range:
The Total duration of time spent in each SIP Field for the Grade of Partners/Office Holders.
The Total duration of time spent in each SIP Field for the Grade of Managers.
The Total duration of time spent in each SIP Field for the Grade of Assistant/Support.
The Average Charge Rate by the Grades for each SIP Field.
The Total TimeCost (Charge Rate * Duration) for each SIP Field.
This needs to all be generated by a simple Case and Date Range Form, with a 'Create Report' button.
I've experienced a range of problems, including extortionately inflated totals and the report wizard refusing to combine multiple, related Queries.
The main table I use is a Timesheet, with columns like 'Start Date' and 'End Date'. I calculate the 'Duration' using DateDiff(). There are also Charge Rates, linked to the Grade of the person recording the time. They can be either Partner/Office Holder, Manager or Assistant/Support. Finally, there is SIP Field, which breaks down the kinds of tasks recorded, e.g. dealing with creditors, trading, realisation of assets, etc.
The Report needs to present the following things for a particular Case over a particular Date Range:
The Total duration of time spent in each SIP Field for the Grade of Partners/Office Holders.
The Total duration of time spent in each SIP Field for the Grade of Managers.
The Total duration of time spent in each SIP Field for the Grade of Assistant/Support.
The Average Charge Rate by the Grades for each SIP Field.
The Total TimeCost (Charge Rate * Duration) for each SIP Field.
This needs to all be generated by a simple Case and Date Range Form, with a 'Create Report' button.
I've experienced a range of problems, including extortionately inflated totals and the report wizard refusing to combine multiple, related Queries.