Paul:

I think I didn't explain very well. <g>

The aggregated field I am referring to is, in the ClientDataSet. I
can create a new field and set it's type to Aggregated and set it's
expression to sum(myField) and it will total all records and give me
a total. The SQL Sum(myfield) will not do that, correct?

Thanks.