Calculate sum from subform

[snuffi01]

I have an form with an subform with data in it.
I would like to have an field in my main form witch calculates the summary from an field in the subform.
I have tried this: =nz([KundkontaktTabellUnderformular].[Formulär]![Summa]).
But i just get the data from the first entry i the subform, and i want it to calculate the summary of all entries in the subform.

 

[nkiefer]

You first need to create an unboud field on your sub form that sums all of the information that you need. This is typically placed in the footer of the sub form. Then you can create another field on your main form and reference the subform control.

 

[Rolliee]

Use DSUM("FieldName","TableName",criteria) using the same fields and tables as the subform with the proper criterion. Place this in the on_current event and it works like a charm.


rollie@bwsys.net