I have a table (tbl125) that holds employees yearly desired contributions to
a medical plan my agency offers. That desired amount is divided by 26 ( we
are paid every 2 weeks) to come up with the amount that will need to be
deducted from each paycheck in order to reach the goal by then end of the
year. I have a query in place that does that. However, now I'd like to take
it one step further and update a field in tbl125 called YTDContributions.
What I would like to have happen is have the YTDContributions field show how
much an individual has actually contributed up to that point. Any ideas?
Thanks in advance!
Klatuu - 20 Nov 2007 19:11 GMT
Storing calculated data in tables is not correct. The correct approach would
be a query that sums the value.

Signature
Dave Hargis, Microsoft Access MVP
> I have a table (tbl125) that holds employees yearly desired contributions to
> a medical plan my agency offers. That desired amount is divided by 26 ( we
[quoted text clipped - 6 lines]
>
> Thanks in advance!