Sum on a form

[thart21]

I cannot get this to work. I've searched forums, NW db and others and cannot seem to find a solution. I am trying to get a subtotal of each of my two columns then a Grand Total of both subtotals at the bottom of the form.

I have tried a Text box in the detail section and then in the form footer w/ control source: =Sum([Field]) and I just get #error.

Any point in the right direction would be a big help!!

Thanks

 

[Rich]

=Sum(Field1+Field2) will give the GrandTotal and Sum(Field1) resp. check your field names. If field 1 is a calculated field on the form this method will not work though, post back for more help

 

[thart21]

Thanks for the fast replies! My form is based on a query which contains calculated fields, but the form itself does not have any calculated fields.

Thanks

 

[thart21]

Thanks for the help! I was making it more complicated than it really was. I did the subtotals in my query.

Subtotals:

qry>50%.Subtotal and qry<50%.Subtotal

Grand Total:

=Sum(Nz([qry>50%.Subtotal]+Nz([qry<50%.Subtotal])))

Thanks again,

Toni