i have several rows that have the same data, e.g code & name. one of the
columns is a number, which is different for each row. I want to merge all
the rows into 1 but i want the number field to be the total.

Can I do this?

stuart.