Sum a column

[cwh13]

is there any way to sum a column or field that has a calculation in them?

[JoeM]

Where?
On a Report, Form, or Query?

[cwh13]

A subform,on the footer of a subform i do not need to see it just use it.

[alcapps]

one thing you can do is create a field on the main form with this as the control source =dbsum("calculation like in calculated field","table or query")
after update of the subform
point back to the text box and requery it.

if the field name was txtCalc in main form..

txtCalc.controlsource = above ..

so in after update of subform
me.parent.txtCalc.requery

one way to approach it.


I would make a function and then call the function after the update but both will work.

hope this helps..

[cwh13]

hello folks let me ask this question in a differant way than i did yeserday.i need to sum a group of calculated records in a field on a subform.i can sum the records in the fields that do not have expression in them but not the fields that do.is there a function that needs to be used in the sum expression?

[pbaldy]

How about:

http://support.microsoft.com/kb/113354