the running total cannot be done in the SQL. you would need to do it in the SQL.
before the repeat region that displays the records, declare a variable to hold the running total:
<?php
$runningTotal = 0;
?>
then add the recordset value to the running total where it gets desiplayd, and show it next to that:
for example:
show total:<?php echo($_RecordsetName['recordCount']);?>
Calculate running total: <?php $runningTotal = ($runningTotal + $_RecordsetName['recordCount']); ?>
Show running Total: <?php echo($runningTotal); ?>