Thankyou, for getting back to me.
A. I have attached some sample data from the Table 'Timesheet' .
I have also attached the Tables 'Task Reference' and 'Charge Table' .
'Fee Earner' joins Timesheet to Charge Table, allowing us to know the 'Charge Rate' and 'Grade' for each record. 'Task'...
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...