>
>Try doing your select with the COUNT() function to get the numbers of rows, or the SUM() function to get the total amounts of the data in the fields...
>
>SELECT SUM(myfield), myfield GROUP BY myfield

Wayne, thanks for your reply.
I dont think the Sum will give me waht I want. I dont want the data grouped or
summed.. I just want a cuulative figure on each record... the same no. of records should be returned with 1 additonal field which will be getting larger all the time (if all numbers are positive)

Gerard