Thank you Paul - that puts me straight.

Thank you Gail,

I'm trying to create a running sum in the stored procedure, which I've managed to do in an Access .mdb as follows:

SELECT Table1.Id, Table1.EntryDate, Table1.Product, Table1.ProdPrice, Table1.Qty, Table1.Rtn,...