Dsum

[rodrigoturbina]

Hi, I would like to display the sum of all the payments referred to an invoice, in an unbound field in a form.

The invoices are stored in the table FACTURAS, and the payments, in the table REC-COB.

The main form is bounded to table FACTURAS and it has a subform bounded to REC-COB. The INVOICE number connects both form and subform (N° DOC <-> FACTURA).

Table: FACTURAS
Field: N° DOC

Table: REC-COB
Field: FACTURA
Field: IMPORTE indiv

If I am displaying the invoice information of FACTURA "A1000", in the subform I currently display all its payments (stored in REC-COB) but I also want to display the SUM OF THOSE PAYMENTS.

I tried:

=DSum("[IMPORTE indiv]",[REC-COB],[REC-COB]![FACTURA]=[detalle_fact]![N° DOC])

* detalle_fact: name of the main form

Hope you can help me, thanks in advance.

 

[rodrigoturbina]

* IMPORTE indiv: name of the field that contains the payment amount