sum a field in all rows
How can I sum the value of a field in all records?
Thanks in advance
You would create field that is a SUMMARY type. When click on create, you are presented with a list of fields to choose the one to sum. Place the field in a sub-summary, footer, or summary part of a layout. It will sum the found records.
I know this works with related records. Use a calculation field in the parent table and use sum(theRelatedFieldtoSum).
I don't know but possibly you may be able to use the same approach in a non related table by putting the fleld in a footer or header area -- just a thought only.
Thanks a lot TKnTexas. Is ther any wany we can make it more specifice like the records are browsed? Not the record in whole database.
Thanks a lot for the solution for my problem. It is sorted. I created a Grand Summary part and I got the correct result.
Retrieving data ...