1 year ago

Query to return totals by job number

Posted 1 year ago by finchy70

I have a table that stores job numbers and hours as shown here.

Data table

I need to total all hours per job number for a specific period. Therefore period 1 result would look like this.

Data table and results

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.

Please sign in or create an account to participate in this conversation.