Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Exclamation Help! Running total on field.

    Hello, all.

    Im using Brilliant Database 9 ultimate and Im stucked on this problem and Imma total noob.

    My question is:
    How to make a running total such described below:

    ========== --------------------========= --============
    Summary ---------------==> ---Summary--||--Running total
    ========== --------------- ---========= --============
    4 ------------------------------||----4--------||------4------
    5-------------------------------||----5--------||-----9-------
    6-------------------------------||----6--------||-----15------
    7-------------------------------||----7--------||-----22------

    Any help will be appreciated.
    Thx in advance.

  2. #2
    Join Date
    Jul 2011
    Posts
    134
    Create a formulae field in the form.When you create a new record create it in relation to the previous one so that it will copy the previous value and add with the present one.

  3. #3
    Join Date
    Jan 2013
    Posts
    3
    Thanks, asokram.
    But I still don't know exactly what you mean of creating relationship with formula field.

    If you don't mind, can you give me a simple example to do that in bbd format?
    Coz I have no idea to do this.

  4. #4
    Join Date
    Jul 2011
    Posts
    134
    Please see the attachment for example.
    Attached Files Attached Files

  5. #5
    Join Date
    Jan 2013
    Posts
    3
    Thank you, Asokram!

    Your formula works like a charm, and exactly what I need.
    Now I can continue my work after stuck for two days of solving this.

    Regards.

Posting Permissions

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