Forgive me for crossposting this- I'm not sure where it should land.....
I am working on a project where I need to build an accumulator in access.

Basically, it would accumulate visits on a subid, memno level by date of service. So if a subid/memno combination had 50 rows, each with a variable amount of visits, it would create or populate a new column with the summation of visits to that point based on date of service. Thus, the value would be different at each row because it would continue to accumulate by date of service.

My guess is that this can be done with a module or a query, I just don't know how.

Please help!!!

Thanks,
Victoria
avvigil@yahoo.com

Duplicate post.

Here is the original post:

http://access-programmers.co.uk/forums/showthread.php?t=173193