sub total sub form values

[Ali29J]

Hi All

I have a master form which i would like to total up all items entered in a continuous subform, could anyone help how i could total all values in the filtered continuous form and show it the master form??

THanks

Ali

 

[PHV]

In the footer section of the continuous form create a textbox with a control source like this:
=Sum([field name])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886