Just use a variable to add up the total as as you move through the recordset.