Hello,I need to compute a running total in a sql query for a report. Presently, I calculate my running total by means of a cursor. As my data being reported on is ever expanding and my cursor ...

The data is on SQL Server 2008 R2. I thought I could do with with some of the built in analytic functions and "OVER" statement, but this version of SQL Server is rather limited in that department ...

There's no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert ...