L
ladybug via AccessMonster.com
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.
Does anyone have any insight on this?
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.
Does anyone have any insight on this?