Trying to Sum details in Footer Crashes Access

[proballin]

I have an equation in my "Details" section that figures out the amount of cars that come in each month. Now in the footer section I want a sum of all the cars. So I tried copying the expression and wrapping Sum around it ( =Sum([equation])). However doing this causes Access to crash when I try and view the report. When I try wrap the given name of the expression in Sum it doesnt recognize the name. Any suggestions.

 

[dkinley]

Just a guess since I am not a pro at this.

In the details, check the properties of the equation control and modify the one that says Running Sum to Yes. Give the control a name like .. txtEquation.

Now in the group or report footer control put in =Sum([txtEquation]) and see if that works.

-dK

 

[proballin]

That worked! I didnt have to put Sum in front of it since it already did the running sum. Thanks!

 

[dkinley]

You betcha.

-dK