R
radraccoon
One table defines budget (each one has a unqiue ID)
Another table defines employees (each one has a unique ID)
Another table defines tasks (each one has a unique ID)
Another table records budgeted time by project, task, employee
Another table records actual time by project, task, employee
I created one query which will total up the budgeted time by project
and employee (so if an employee was assigned multiple tasks on the
same project, you'll just get one total for that employee for that
project).
I created another query which will total up actual time byt project
and employee (so if an employee worked multiple tasks on the same
project, you'll get one total for that employee for that project).
Now ... how do I compare the two? I can only get queries to show the
differences for employees who were both budgeted to a project AND
worked on a project. How do I also get it to show employees who were
budgeted to a project but did not work on it as well as those not
assigned to a project but did work on it? (Near as I can tell, left-
and right- joining will get me one way, but you can't do both in the
same query? And even then, I would end up duplicating employees who
were both budgeted and worked if I did it that way.)
Any help would be appreciated.
Another table defines employees (each one has a unique ID)
Another table defines tasks (each one has a unique ID)
Another table records budgeted time by project, task, employee
Another table records actual time by project, task, employee
I created one query which will total up the budgeted time by project
and employee (so if an employee was assigned multiple tasks on the
same project, you'll just get one total for that employee for that
project).
I created another query which will total up actual time byt project
and employee (so if an employee worked multiple tasks on the same
project, you'll get one total for that employee for that project).
Now ... how do I compare the two? I can only get queries to show the
differences for employees who were both budgeted to a project AND
worked on a project. How do I also get it to show employees who were
budgeted to a project but did not work on it as well as those not
assigned to a project but did work on it? (Near as I can tell, left-
and right- joining will get me one way, but you can't do both in the
same query? And even then, I would end up duplicating employees who
were both budgeted and worked if I did it that way.)
Any help would be appreciated.