I don't think you can do it with a SQL statement. You'll need to pull the data into a read/write cursor, adding a column for the running total, then scan the cursor to populate that column.
>Hi. How do I show a running total in a grid column (like in a bank statement)? If not, how would you do the same in a SQL statement? thanks, randy
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer