hi!!!!

incase it is a continuous form it is going to be bound form.

add unbound textboxes in the footer section.

assuming there as two columns

if the name of the textboxs are txtTotalCol1 and txtTotalCol2
the name of the fields are Col1 and col2

in the control source of the first textbox add the following code

=Sum([Col1]) ' this will give the total of Col1

in second textbox

=Sum([Col2]) ' the total of Col2

if incase u want the grand total of both the columns, add another
unbound textbox( say named txtGrandTot)

txtGrandTot = cInt(txtTotalCol1) + cInt(txtTotalCol2)

u have the total

if incase u are using unbound form

u can loop thro the recordset and total it up. the upper bound of the
loop being the record count

thanx and hope this helps

regards