Tracking Changes

[StarhawkGamer]

I've got a database where I get records about agent performance. Part of the database includes who their supervisor is. I need to be able to track who their supervisor was on any given date or date range and assign only the records from the date(s) they were assigned to the supervisor to the supervisor to track performance of the supervisor. What is the best way to try and accomplish this? The primary data source in question does not report the supervisor information along with the agent information, but other sources do report this.

 

[dhookom]

I would create and maintain a table with a structure like:
[tt][blue]
tblAgentSupervisors
=======================
AgSuID
AgentID
SupervisorID
EffectiveDate
[/blue][/tt]

You could add an EndDate to make querying a little easier.

Duane
Hook'D on Access
MS Access MVP