Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    16

    Unanswered: SUM of unbound textbox in Continous forms

    I have a unbound textboks on a continous form.
    On each record there will be a different value in this textboks.
    I want to show the SUM of all these values in the Footer, how do I do this?

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Try This:
    Create a hidden textbox. Name this TextBox AddItUp. In the ControlSource property for this hidden text box enter:

    =Sum([theControlNameYouWantToSum])

    In the TextBox located in Footer, place the following into its' ControlSource Property:

    =[AddItUp]


    Last edited by CyberLynx; 10-25-04 at 19:03.

  3. #3
    Join Date
    Sep 2004
    Posts
    16
    Yes this is ok with bound textboxes, but with unbound I can't get it work.

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    Make a small sample db and attach it to a post. Lets see what we can do with it.



  5. #5
    Join Date
    Sep 2004
    Posts
    16
    I have rebuilt, and are now using a query instead. But txt anyway.

Posting Permissions

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