sum function in form footer?

[raychoy2k]

I was wondering if I use a Sum function in the footer of a FORM for one of the fields, should it sum all the values in the table for that field? I assume so, but it is not working!!

[ext_total]<-- field in record

------Footer ------
sum([ext_total])

Then should I get the sum of all the [ext_total] for the whole table?

 

[Jack Cowley]

Add an unbound control to the forms footer and use this as the Control Source for the control:

=Sum(ext_total)

hth,
Jack

 

[boblarson]

Also, make sure your control name is NOT the same as your field name.