L
ladybug via AccessMonster.com
Part of my posting was cut off....here is the whole issue...
I have two tables. First table holds total errors that employee received.
The employee receives a total # by month. Month (ex. 06-Feb)
The Second table holds Supervisor/Employee Relationship. It has Supervisor
ID, Employee ID, Begin Date(Date the employee started under that particular
Supervisor), End Date (Date employee stopped working under that Supervisor).
Begin and End Dates (ex.01/01/06)
Now I want when you prompt the query for which Supervisor and Month it will
provide only the employees that worked under that particular Supervisor at
that time. The trick is if an employee stops working for Supervisor A on
March 14th and Starts working under Supervisor B on March 15th I need to show
them on both Supervisors reports for that month.
Does anyone have any insight on this?
I have two tables. First table holds total errors that employee received.
The employee receives a total # by month. Month (ex. 06-Feb)
The Second table holds Supervisor/Employee Relationship. It has Supervisor
ID, Employee ID, Begin Date(Date the employee started under that particular
Supervisor), End Date (Date employee stopped working under that Supervisor).
Begin and End Dates (ex.01/01/06)
Now I want when you prompt the query for which Supervisor and Month it will
provide only the employees that worked under that particular Supervisor at
that time. The trick is if an employee stops working for Supervisor A on
March 14th and Starts working under Supervisor B on March 15th I need to show
them on both Supervisors reports for that month.
Does anyone have any insight on this?