Hello and thanks in advance for your help,
I am trying to create a payroll report, using a Work Order (WO) file. I would like the report to display the following things.
Pay period start and end date:
Total pay period hours
Total pay period overtime
If any work orders within a day overlap (This is not as important, and was thinking of just having conditional formatting highlight these red)
The fields in WO that I'd like to use are, ServiceTech, Date, TimeIn, TimeOut, TotalService (The duration of the workorder).
Honestly, I've been reading lots of documentation, but I'm still not really sure how to go about doing this. Do I create a new Table with the fields I want and relate it to WO table, should I make a whole new Pay Roll file and relate that to the WO file. Which fields should I join? Any input would be greatly appreciated. Thanks!