formula for a nested subform into other form

  • Thread starter Thread starter gabh81
  • Start date Start date
G

gabh81

Hello!!!,,,I need an urgent help in a formula.

I have the tables:
[Ship] [Invoice]
[Payments]
IdShip (keyfield) ----------------> IdShip
IdInvoice
DateShipped IdInvoice (keyfield) --------->
AmountPaid
Port AmountInvoiced
DatePaid
Customer
DateInv

I have a form A, which contains a key field "IdShip". Each IdShip contains
more than one invoice, called IdInvoice (key field too), and each IdIvoice
have several Payments.

So, I have form A with IdShip, with the subform showing different Invoices,
and the subform is nesting the Payments subform as a 2nd subform.

What I want, it is to show in the Form A the total per IdShip for amounts
invoiced and paids.

I already did for the invoiced amounts, using a text box:
SumInvAmt =nz(Sum([InvAmount]),0), I add this formula in the form footer of
Subform1, and then in Form A, I used another text box: =SumInvAmt...and works
fine, adding all the invoiced amounts which belongs to the respective IdShip.

but I'm not able (or I dont know how) to do the second (for the subform2, or
in a way to say, for the sub-subform) ,,,,to do a formula which shows ALL the
amounts for the different payments presents for the differents invoices in a
particular Idvessel.

any,,,any help will be very appreciated. Thanks in advance,

gab
 
gabh81 said:
Hello!!!,,,I need an urgent help in a formula.

I have the tables:
[Ship] [Invoice]
[Payments]
IdShip (keyfield) ----------------> IdShip
IdInvoice
DateShipped IdInvoice (keyfield) --------->
AmountPaid
Port AmountInvoiced
DatePaid
Customer
DateInv

I have a form A, which contains a key field "IdShip". Each IdShip contains
more than one invoice, called IdInvoice (key field too), and each IdIvoice
have several Payments.

So, I have form A with IdShip, with the subform showing different
Invoices,
and the subform is nesting the Payments subform as a 2nd subform.

What I want, it is to show in the Form A the total per IdShip for amounts
invoiced and paids.

I already did for the invoiced amounts, using a text box:
SumInvAmt =nz(Sum([InvAmount]),0), I add this formula in the form footer
of
Subform1, and then in Form A, I used another text box: =SumInvAmt...and
works
fine, adding all the invoiced amounts which belongs to the respective
IdShip.

but I'm not able (or I dont know how) to do the second (for the subform2,
or
in a way to say, for the sub-subform) ,,,,to do a formula which shows ALL
the
amounts for the different payments presents for the differents invoices in
a
particular Idvessel.

any,,,any help will be very appreciated. Thanks in advance,

gab
Click to expand...
 
Sorry Martin,,,but if you posted a reply, it didnt appear...

esterer.martin said:
gabh81 said:
Hello!!!,,,I need an urgent help in a formula.

I have the tables:
[Ship] [Invoice]
[Payments]
IdShip (keyfield) ----------------> IdShip
IdInvoice
DateShipped IdInvoice (keyfield) --------->
AmountPaid
Port AmountInvoiced
DatePaid
Customer
DateInv

I have a form A, which contains a key field "IdShip". Each IdShip contains
more than one invoice, called IdInvoice (key field too), and each IdIvoice
have several Payments.

So, I have form A with IdShip, with the subform showing different
Invoices,
and the subform is nesting the Payments subform as a 2nd subform.

What I want, it is to show in the Form A the total per IdShip for amounts
invoiced and paids.

I already did for the invoiced amounts, using a text box:
SumInvAmt =nz(Sum([InvAmount]),0), I add this formula in the form footer
of
Subform1, and then in Form A, I used another text box: =SumInvAmt...and
works
fine, adding all the invoiced amounts which belongs to the respective
IdShip.

but I'm not able (or I dont know how) to do the second (for the subform2,
or
in a way to say, for the sub-subform) ,,,,to do a formula which shows ALL
the
amounts for the different payments presents for the differents invoices in
a
particular Idvessel.

any,,,any help will be very appreciated. Thanks in advance,

gab
Click to expand...
Click to expand...
 
Back
Top