I haven't been around much, since they're asking me to program in Access. I don't mind, since I'm learning it on their time.

I need to make a running total cursor that will be fed into a graph. For example, if I have this:

datefield          numfield
01/01/98        4
01/08/98        10
01/15/98        6

...the output would be:

datefield          runningsum
01/01/98          4
01/08/98          14
01/15/98          20

To be honest, they're asking for it in Access, but I figure it's an interesting problem for you folks as well. I suppose that the answer would apply in any version of SQL. The Access help says you can use their Domain Aggregate functions for this (i.e. DSUM), but doesn't say how. I don't see such functions in VFP3, so I guess the answer might involve a UDF handcrafted to make a "domain sum" and plugged into a SELECT - SQL.

You probably guessed that I haven't found a place on the web to pose my Access questions. Does anybody know of one?

Thank you.