Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    18

    Unanswered: Sum in continuous sub_form

    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.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    where have you put the control
    #ERROR normally indicates a typo, spelling mistake and or the Access runtime cannot find the named control / column
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    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)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •