How to calculate a sum on a subform

[hdesbiens]

Hi

i have a form list of invoice, that form contains a subform called listallinvoices that shows me alle the invoices in the system.

I have manu dropdown fields that filter the subform depending on what we want it to be filtered or sorted.

What i want to dow is put sumsubtotal, sumtps, sumtvq, sumtotal fields on my form that will calculate all the records contained in my subform.

Is there an easy way to do that?

Thanks a lot

 

[Remou]

You can use Sum in the subform footer. In a textbox:

=Sum([Total])

 

[hdesbiens]

Ok thanks

i trying to do that but it seems that in datasheet mode the field that i put in the footer does not appear?

is it possible to do that in a datasheet subform?

thanks a lot

 

[Remou]

Not that I know of. You get much more control with a continuous form. A continuous form can be made to look very like a datasheet.