I have a table that stores job numbers and hours as shown here.
I need to total all hours per job number for a specific period. Therefore period 1 result would look like this.
The data table extends to include 3 job number entries for each day.
Anyone able to help me build the query for this?
Thanks in advance.