Linking tables and adding fields

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
 
A

Arvin Meyer [MVP]

It makes absolute sense. Fortunately Access is one of the very few DBMS that
can connect dissimilar data sources in a query. As long as you aren't
updating one of the accounting tables, you can experiment until you get what
you need. To get the data from the second database, choose File ... Get
External Data ... Link and add the ones you want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top