Thank you GetMem, just tried your sample and it "works like a charm", this is just what I wanted.
In my past Visual Foxpro experience, I would just Select the Dataset into a temp Cursor and SUM the amount in the Cursor. A 3-liner statement solution. I was wondering how to do that in Lazarus.
Unfortunately the demise of Visual Foxpro forced me to migrate to another platform and Lazarus/Firebird seems to be a good alternative platform and I am enjoying the long and tedious relearning process.
Thank you again, GetMem, TRon, dsiders and mig-31 for your help, greatly appreciate it.
Be Safe from Covic-19.