Hello everyone.
I'm in over my head on this and need help on this. I need to produce a report that represents employees hours per day and it needs to show daily totals and employees totals. The user should be able to enter start and end dates that span eight days on any eight day period. Sunday through Sunday for example. Below is what it needs to look like:
Driver Hours
For period xx/xx/xx through xx/xx/xx
Sun Mon Tue Wed Thr Fri Sat Sun Total
Name xx/xx/xx xx/xx/xx xx/xx/xx xx/xx/xx xx/xxxx xx/xx/xx xx/xx/xx xx/xx/xx
Doe, john 12 11 0 0 13 13 12 0 61
Smith,jim 0 0 12.5 11.5 13 12.5 13 0 62.5
wilson,jack 0 12 11 13 12 13 12 0 73
Totals 12 23 23.5 24.5 38 38.5 37 0 196.5
I dont ask for code but can someone please just instruct me on how to go about doing this? Any input will be appreciated.