>I know I've read an article some where that shows tricks to use to get running totals in a SQL cursor or view. Does anyone have a reference to this article (FoxTalk or FPA)? Or, does anyone know how to do this.
Rick,
I don't know about this special article. But if you want to run totals everything sums up to do a SELECT SUM(
) AS GROUP BY
And eventually add a HAVING clause to filter your groups.
José