creating a calc column from 2 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables. One table has a column with data, lets say a staff saw 20 people in a 2 week period in his/her primary dept. Lets say that same staff works in another dept part-time. that info needs to be captured. right now I store this info in 2 separate tables. The tabels are the same. I just need a way to add the additional time onto the primarr time for a total. However some staff really only work in one dept. and I still want this data in the column that computes the duration.

Any ideas:

Thanks
 
Neil,

Do you mean you have a separate table for each Department? Any reason
for this? Is there a possibility that this design could be changed?

- Steve Schapel, Microsoft Access MVP
 
When you said "The tables are the same." that reveals a
design flaw. You should not have two tables with the same
fiels in them. I suggest you combine them like this:

In ONE table, have the workers' information like name,
phone, primary department, etc. In the other table,(this
is where you combine the two tables you now have) have the
fields: Department, PeopleSaw, Hours, etc.

Then, enter the hours and people saw IN EACH DEPARTMENT:

WORKER DEPARTMENT HOURS PEOPLESAW

John P. Marketing 1.5 2
John P. Sales 1.0 3
Mary Q. Repair 3.5 2

Another way would be to have a Department TABLE with a
list of all the different departments and their
information such as supervisor, phone extension, hours
etc. Then use this info., either linked or unlinked in
the database.

Then use this to draw out the information you want through
queries.
 
Back
Top