How to SUM a field in the SQLQuery dataset to a variable

[erictan]

Thanks delphi2pk, will give your sample a run too.

Genmem's code runs well and the logic is quite similar to your code though using slightly different statements.