L
Linda
I have a database for collecting data about employee contributions to
a 401k plan. I use the data to calculate employee contributions and
employer contributions. I have a query to summarize on an annual basis
how much each employee contributes and what the company contribution
was based on a formula (company matches 50 cents on the dollar up to
8% of the employees gross pay unless the employee contributes less
than 8%). The employee table includes name, ss# and % contribution.
Occasionally people change the % they want to contribute. This messes
up my annual report because the underlying query takes the current %
contribution from the employee table and doesn't use the actual % that
was used at the time of the contribution.
Thanks,
Linda
a 401k plan. I use the data to calculate employee contributions and
employer contributions. I have a query to summarize on an annual basis
how much each employee contributes and what the company contribution
was based on a formula (company matches 50 cents on the dollar up to
8% of the employees gross pay unless the employee contributes less
than 8%). The employee table includes name, ss# and % contribution.
Occasionally people change the % they want to contribute. This messes
up my annual report because the underlying query takes the current %
contribution from the employee table and doesn't use the actual % that
was used at the time of the contribution.
Thanks,
Linda