Adding values from SQL database

I'm currently trying to add (sum) the values from a field within an SQL database. I would like to do this without using SQL itself if possible.

I thought of using ASP/VB Script and so far have managed to display the top value within the field but i need to know how to do a loop or another method to add up all of the values within the recordset field.

This is my code so far;

Dim totalcost
Dim paymentdue

totalcost = (Recordset1.Fields.Item("pricetotal").Value)

paymentdue = totalcost

Thanks for your help....