Summing fields in subform

C

CRBI

I have a members database with a table for member info and a table for their
contribution amounts. I have created a form based on the member table with a
subform from the contributions table. Since a single member can make several
contributions within one year, I want a field next to the subform to sum the
total contributions that particular member has made to date. I can't seem to
get the syntax right to make that work. I created an unbound text box and
used the following syntax:

=sum(Forms![Contributions Subform]Amt!)

I built this using expressions.
 
C

Cheese_whiz

Hi CRBI,

You could use DSum:

=DSum("Amt", "Contributions", "MemberID = " & Me.txtMemberID)

Assuming:
"Amt" is the field in your subform's recordsource (table or query) where
donation amounts are stored.

"Contributions" is the name of your table or query that holds contribution
records

"MemberID" is the primary key from your main form's recordset (table or
query), and it's a number type field (could/most likely is an autonumber)

"txtMemberID" is the main form control that is bound to the memberId field
in your main form's recordsource

HTH,
CW
 
D

Dale Fye

Another way to address this would be to put the Total control in the footer
of the subform. Then all you would need to do is in the ControlSource of
that textbox enter: =Sum([Amt])

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Top