Running Sum in Subreport

[allong]

I would like to get a running sum in my subreport in the main report. If I view the subreport alone the running sum totals are there. When I view the main report, I do not get the running sum. What is it I am doing wrong? Can anyone help me with this problem?

 

[CosmoKramer]

Is this RunningSum control in the page footer of the subreport?? If so, try moving it to the report footer.
Access doesn't print the page header and footer in a subreport.

 

[allong]

CosmoKramer I have tried it in the report footer and I get a 0. When I open the subreport by itself it works fine. It is not working when I open the main report. Right now I have the running sum in the group footer.

 

[CosmoKramer]

You said the running sum is in the group footer. What appears in that control when you run the main report??

0, null, #Error, etc....

 

[allong]

CosmoKramer when I run the main report I get the same number that is in my employee total control.