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.
Marshall Barton just answered a similar question in the queries news group
less than two hours ago. Look for a subject of "Running Total"

Signature
Duane Hookom
MS Access MVP
>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
[quoted text clipped - 16 lines]
>
> Thanks.
Craig - 06 Dec 2005 19:17 GMT
Thanks.

Signature
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"
[quoted text clipped - 19 lines]
> >
> > Thanks.