Building an accumulator in access- module or query and how to?

[Victoria]

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, I just don't know how.

Please help!!!

Thanks,
Victoria
(e-mail address removed)

 

[Jeff Boyce]

Victoria

From your description, you are trying to calculate and store a value.

Since the value of the calculation would change every time there's another
visit, don't store it!

Instead, you can use a query (or the DCount() function) to calculate that
value "on the fly". This way it will be accurate every time it gets
calculated, and there would be no need for coming up with functions to
ensure synchronization of the 'stored' value.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP