Cummulative Query Function

[Guest]

I am using Access XP. I would like to create a query that returns a
cummulative number for a given person, then starts over with the next person.

for example. Assume Expr1 returns the cummulative query function:

Name Amt Expr1
------ ----- ------
Smith 2 2
Smith 3 5
Smith 4 9
Jones 1 1
Jones 3 4
Jones 2 6
Jones 1 7
..
..
..etc...

Thanks.

 

[Duane Hookom]

Marshall Barton just answered a similar question in the queries news group
less than two hours ago. Look for a subject of "Running Total"

 

[Guest]

Thanks.
--
Craig

Marshall Barton just answered a similar question in the queries news group
less than two hours ago. Look for a subject of "Running Total"