Total values for one day only

[jk12]

Hi. In my query I have a Name column, day column (With a drop down box for the 7 days) and 10 task columns showing hours worked on each task.

I need to try and find a way automatically calculate to show the total hours worked for each specific day for each person and show each total value on a report and in a form.

Any Ideas?????

 

[KenHigg]

1. You really need to normalize you tables
2. Having said that a work around may be to create a col in the query and simply add all the flds together.

MyNewTotals: [task1] + [task2], etc...