total in a subform

[ingrid]

I created a subform and want to show the total of the field "vaantal" in the footer.

I tried this:
Create texbox in the formfooter. In the controlsource I placed:
=SUM([vaantal])

but this doesn't work. I'm using access 97. What am I doing wrong?

 

[Rich]

In the subForm footer?

 

[ingrid]

In the formfooter on the subform. I also tryed to place it in the Pagefooter on the subform but thatone I don't see when I show the subform.

 

[Rich]

Add another control to the main form and set its controls source to the textbox in the subForm footer

 

[ingrid]

that also doesn't work.

 

[stormin_norm]

Where is vaantal field? On the subform or on the main form?

 

[ingrid]

On the subform (in the footer).

 

[stormin_norm]

ah, so try putting nz([vaantal]) in the subform detail and keep Sum([vaantal]) in the subform footer. Should work fine.

-norm.