Sum of multiple columns
Posted on 2014-03-21
I have an old database that looks like this:
Job Tech1 Hours1 Tech2 Hours2 Tech3 Hours3
A Bob 1 Sam 2 Joe 3
B Sam 2 Joe 3 Bob 1
C Joe 3 Bob 1 Sam
The people in the database can fulfill different rolls on a job so they are put in different columns.
I need a query that figures out the total for each person. In the above case, this would be:
Tech Total Hours
I have this in an Access database with multiple queries that perform the calculation, but am looking for a way to simplify into 1 query.