Mega Code Archive

 

Categories / Delphi / ADO Database

 

Adding sums of fields

Question: I want to sum several fields and then sum those sums - how do I do this? Answer: Just create a entire new sum expression, adding all the fields together: QRExpr1.Expression := Sum(Field1); QRExpr2.Expression := Sum(Field2); QRExpr3.Expression := Sum(Field1+Field2);