You can easily add aggregates to recordsource using Dataenvironment instead of
ADO data control.

>I have a grid on a form with a ado control and when I run the form the grid is populated. From a command button on the form how would I write the code to sum a field I have called amountTotal.