Calculation control on form

[pablavo]

Hi

I'm trying to use a control to calculate a bunch of related records on a form.

I'll just clarify my setup.

The parent form is called "frmProject" that will list different Projects an organisation is working with.
It's child form is called "frmApproved" which has a total amount of funds that will be approved for a project. and it's child form "frmPayment" has a breakdown of each payment that is sent, sometimes in two installments.

There can be many years of Approved amounts for one project. For example, one project might have many records with Approved amounts for say, 5 years (5 records). So there could be a break down of two payments sent per Approved amount.

for example
Project One = 5 Approved amounts (5 records) = 2 Payments per Approved amount (10 records)

All I want to do is to be able to put a calculated control on one of the forms that will tell me all the payments that have actually been sent for that project.

I'm trying to use the Dsum but I can only get the current record from frmpayment showing on the calculated control which means I'm not using it correctly.
Is there a way to show all the Payments sent for that project?

I'll be grateful for all help!

 

[boblarson]

Put a text box in the footer of the frmPayment with =Sum(Nz([YourPaymentFieldNameHere,0)) and then you can put a text box on your main form that references that text box:

=[YourSubFormContainerNameHere].[Form]![YourTextBoxWithTheSumOnTheSubFormHere]