Sum Field

[Guest]

Hello,

I have a Form that contains two tables: "Customer" and "Loan." The "Loan"
table is the subform. Customer ID is the primary key in the "Customer" table
and has a one-to-many relationship with the "Loan" table (one customer can
have multiple loans). One of the fields in the "Loan" table is [Active
Principal Balance]. How would I go about totaling all the records associated
with this field in the subform? I was thinking of two different formats:

Example 1:
LOAN # ACTIVE PRINICPAL BALANCE TOTAL
Loan 1 100,000
Loan 2 200,000
Loan 3 150,000
450,000

Example 2:
LOAN # ACTIVE PRINICPAL BALANCE
Loan 1 100,000
Loan 2 200,000
Loan 3 150,000

Total 450,000

Thanks in advance,
Brett

 

[John Vinson]

Hello,

I have a Form that contains two tables: "Customer" and "Loan." The "Loan"
table is the subform. Customer ID is the primary key in the "Customer" table
and has a one-to-many relationship with the "Loan" table (one customer can
have multiple loans). One of the fields in the "Loan" table is [Active
Principal Balance]. How would I go about totaling all the records associated
with this field in the subform? I was thinking of two different formats:

Example 1:
LOAN # ACTIVE PRINICPAL BALANCE TOTAL
Loan 1 100,000
Loan 2 200,000
Loan 3 150,000
450,000

Simply put a textbox on the subform's Footer (you need to use a
Continuous form, not a subform); on the footer put a textbox labeled
Total with a control source

=Sum([Active Principal Balance])

This will sum the values displayed on the subform.

John W. Vinson[MVP]