DateAdd help

[Guest]

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!

 

[Guest]

Storing calculated data in tables is not correct. The correct approach would
be a query that sums the value.