Question 1: A box that totals several fields from a subform?

[yogi71]

I have a form, frmSubmitTime.
It has a subform, frmTimeSheetReview which is a Datasheet.
In subTimeReview are columbs, Name, Site, WeekEndDate, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

I want to put a field on frmSubmitTime that takes the values of Sunday, Monday-Saturday and adds them up. The datasheet contains multiple rows and only shows the WeekEndDate that was established in a previous form, that variable was passed to this form upon open.

I had originally thought, if I put the "default value" or the "control source" to the following, it would work.

=[frmTimeSheetReview].[Form]![Sunday]+[frmTimeSheetReview].[Form]![Monday]+[frmTimeSheetReview].[Form]![Tuesday]+[frmTimeSheetReview].[Form]![Wednesday]+[frmTimeSheetReview].[Form]![Thursday]+[frmTimeSheetReview].[Form]![Friday]+[frmTimeSheetReview].[Form]![Saturday]

Alas, it did not.

What am I doing wrong? Is it even possible? I'm rusty with Access, and having to relearn waay to much in a short time.

 

[yogi71]

In case anyone finds this post for an answer....since no one answered....

I built a seperate query that did a Sum on each of the Day of Week fields by user and weekEnd date. So it totaled all of Sunday for each week for each user, and all of Monday...etc.

Then, in the Query builder of the form, I used Sum(Nz[Sum of Sunday]+Nz[Sum of Monday]+etc....)

Works just like I expected.