I want to design a database that includes 2 fields that collect a dollar amount. Is it possible to have these two fields total themselves? I don't want both fields to total together, I want field 1 to total and field 2 to total seperate of each other.

Do you want to keep running totals for each column? If so, just update that column to current_amount = current_amount + new_amount.

Rich