If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summing in Footer
Hello,
I have the following Footers and Fields, which I need to sum on. I saw a OVER GROUP comment made in other posts, but that does not seem to work: WEEK FOOTER: Field: txtSumHrs: =IIf(Sum([HoursWork])40,40,Format(Sum([HoursWork]),"Standard")) Field: txtSumHrs1: =txtSumHrs (Running Sum Over Group) NAME FOOTER: Field: =txt72: ([txtSumHrs1]) - This is my problem. It does not sum across 2 or more weeks, rather, just gives me the last week data. What am I missing? -- David |
#2
|
|||
|
|||
Summing in Footer
I don't think you have a good understanding. First, don't format values that
you want to do math with. Use the format property to set display formats. I expect what you refer to as "Fields" are actually controls. Try set the control txtSumHrs1 to: Control Source: =IIf(Sum([HoursWork])40,40,Sum([HoursWork])) Running Sum: Over Group Then set the text box in the [Name] footer: Control Source: =txtSumHrs1 -- Duane Hookom Microsoft Access MVP "David" wrote: Hello, I have the following Footers and Fields, which I need to sum on. I saw a OVER GROUP comment made in other posts, but that does not seem to work: WEEK FOOTER: Field: txtSumHrs: =IIf(Sum([HoursWork])40,40,Format(Sum([HoursWork]),"Standard")) Field: txtSumHrs1: =txtSumHrs (Running Sum Over Group) NAME FOOTER: Field: =txt72: ([txtSumHrs1]) - This is my problem. It does not sum across 2 or more weeks, rather, just gives me the last week data. What am I missing? -- David |
#3
|
|||
|
|||
Summing in Footer
That worked well. Thanks.
-- David "Duane Hookom" wrote: I don't think you have a good understanding. First, don't format values that you want to do math with. Use the format property to set display formats. I expect what you refer to as "Fields" are actually controls. Try set the control txtSumHrs1 to: Control Source: =IIf(Sum([HoursWork])40,40,Sum([HoursWork])) Running Sum: Over Group Then set the text box in the [Name] footer: Control Source: =txtSumHrs1 -- Duane Hookom Microsoft Access MVP "David" wrote: Hello, I have the following Footers and Fields, which I need to sum on. I saw a OVER GROUP comment made in other posts, but that does not seem to work: WEEK FOOTER: Field: txtSumHrs: =IIf(Sum([HoursWork])40,40,Format(Sum([HoursWork]),"Standard")) Field: txtSumHrs1: =txtSumHrs (Running Sum Over Group) NAME FOOTER: Field: =txt72: ([txtSumHrs1]) - This is my problem. It does not sum across 2 or more weeks, rather, just gives me the last week data. What am I missing? -- David |
Thread Tools | |
Display Modes | |
|
|