I have a continuous sub_form. On that form there is a Debtor and Creditor Field.
I want to add all Debtor and all Creditor in a separate field. If I use sum function, it gives me #ERROR.

where have you put the control
#ERROR normally indicates a typo, spelling mistake and or the Access runtime cannot find the named control / column

A common reason for this error, in this type of scenario, is using the Control name rather than the Field Name in the Function. If the names are identical, the Access Gnomes can usually deal with it, but you cannot run Aggregate Functions against Controls, they have to be run against Fields.

Linq ;0)>