G
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!
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!