I am using Access 2007 and have inherited a database. It has linked tables of information in the form of Excel spreadsheets, that have been extracted from the main system. The user wants help in developing a much faster and customized approach to billing the customer for payroll related information.
There is a table of payroll billing transactions and it has the following record lay-out,
job_num, employee number, employee name, union group, rank, regular hours, overtime hours, other hours, trans_date_ seq_num
e.g. 6430, 2301, john doe, 1, F, 8.0, 0.0, 0.0, 12/01/2012, 254333
On December 1st John doe worked 8.0 regular hours as a pipefitter foreman on job number 6430 and this is record (sequence) number 254333.
There is another table that defines the union groups. I am not concerned with this information at this time.
The seq_num is a sequentially and uniquely assigned number that is posted to the payroll billing record by the main system.
There is also a Rate Master table of billings rates, and it has the following record lay-out,
job_num, union group, rank, regular_billing_rate, overtime_billing_rate, other_billing_rate
I am struggling with how to relate these two tables so that I can develop one or more queries from it.
Any help would be greatly appreciated.
