> Is there any way of doing this using SQL or am I going mad? yes, there is Row sums and the "totals" row http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid 424565_tax285649,00.html > Shall I go back and just do it in ASP? you could, because doing it in a stored procedure is quite efficient rudy