SUM on Main form

P

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?
 
V

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?
Click to expand...

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
 
Top