SUM on Main form

[Pietro]

Hi,

I have a subform (displayed as datasheet view) that contains the field
countcar
i want to SUM on my main form form this field
How ca i do this?

 

[vbasean]

Hi,

   I have a subform (displayed as datasheet view) that contains the field
countcar
i want to SUM on my main form form this field
How ca i do this?

I found this solution the best

add a text box to your main form

have it's data source as: =DSum("[your field to sum]", "[the table/
query the field resides]", "[child field] = " & [parent form id
field])

that usually does the trick