A
Adam Armstrong
Hi all
I have a problem in that I need to manipulate data contained in a
database to conform to some weird pension rules. The gross/net pay is
stored according to pay period, but the individual pay elements are only
stored on a temporary basis. For example, I have one table called Pay,
with fields for Employee ID, PayPeriod, GrossPay, NetPay, .... and
another table called VAR (for variable pay elements). The VAR table
changes every month, and doesn't maintain records according to
PayPeriod.
These tables cannot be changed as they are part of a payroll package.
However, I have created a second database that links to the payroll one.
As I need to create a record of the variable pay elements for each pay
period, I was wondering if there is a way to link the tables, but be
able to force a PayPeriod field into the data so that it doesn't
overwrite the previous pay periods details. Either that, or import the
details directly into a table, but have a query which asks for which pay
period the information relates to. Does any of this make sense?!
Any and all help would be gratefully received!
Adam
I have a problem in that I need to manipulate data contained in a
database to conform to some weird pension rules. The gross/net pay is
stored according to pay period, but the individual pay elements are only
stored on a temporary basis. For example, I have one table called Pay,
with fields for Employee ID, PayPeriod, GrossPay, NetPay, .... and
another table called VAR (for variable pay elements). The VAR table
changes every month, and doesn't maintain records according to
PayPeriod.
These tables cannot be changed as they are part of a payroll package.
However, I have created a second database that links to the payroll one.
As I need to create a record of the variable pay elements for each pay
period, I was wondering if there is a way to link the tables, but be
able to force a PayPeriod field into the data so that it doesn't
overwrite the previous pay periods details. Either that, or import the
details directly into a table, but have a query which asks for which pay
period the information relates to. Does any of this make sense?!
Any and all help would be gratefully received!
Adam