Field that add up the numbers in a specific field among all found records
Again I found myself with a task that I can't solve. I hope somebody are able to help me!
I have a field A which contains a price that differs from record to record. Then I have a botton which preform a script finding all the records that have not paid the amount contained in field A, which already works. Now I would like another field B to add up the amount that all the records just found toegether contains in field A, hence the adding calculation goes acrosse the found records. This field B should only display a value when just used the script. I'm thinking that summarizing of field A's content should be within the script, but don't know which script functions to use. Other than that the content of field B should empty when ever leaving these found records.
Hope somebody understands what i'm writing otherwise please let me know.