Editing data grabbed from a recordset

[Wykrhm]

Is it possible to edit data that is grabbed from a recordset? In my case, I am trying to add quantities together so that I can get a total. So an example of what I am trying to do would be:\[code\]<% set rs = server.CreateObject("ADODB.recordset") totalqty = 0 do NOT while rs.EOF totalqty = totalqty + rs("QTY") loop>%\[/code\]Whenever I tried to do something like this, I would always get an 'Type MisMatch' Error and I'm not sure how to resolve this problem.As always, any and all help would be appreciated.