Im trying to add the value in the database so the value will keep accumulating instead of just updating.

VB Code:
  1. rs(1) = amt

  2. rs(9) = amt + rs(9).value

Whenever I key in a value(amt), it will be store in rs(1) in the database, so now I wants to created a new column "rs(9)" for the accumulating value. Whats wrong with this code or is there anyway I can do? Please advice...