Jump to content
  • 0

Tables and records automation



5 answers to this question

Recommended Posts

  • 0


I want to carry the number in field 4 of row 1 (this field is called ending balance) to field 1 row 2 which is called beginning Balance so i can continue with my calculations on row 2

Then I want to carry the number in field 4 row 2 to field 1 row 2 and so on.

My ending balance in one row (record)  is my beginning balance in the next row (records)



Link to comment
Share on other sites

  • 0

Hi, just to add to the previous comment above, are you looking for a workflow like a running balance? If that is the case, you can use a calculated field instead. 

You may use this formula:

(SELECT SUM(IsNull(Balance, 0)) FROM Running_Balance WHERE Date <= target.[@field:Date])


Balance is the name of the field where I store the amount and Running_Balance is the name of the Table. You may change these names based on your corresponding field names.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...