cadkins
asked on
Department Transfer Report
Hi,
I'm trying to create a report that shows employees who transfered from one department to another. I have only one difficulty though. I want to show their current department and their previous department. How can I show the previous department?
There is a position history table that shows all the departments that an employee has been to. So basically the last entry in that table shows the current department ,and the entry before the last shows the previous department. How can I show the entry before the last in my report?
Thanks
I'm trying to create a report that shows employees who transfered from one department to another. I have only one difficulty though. I want to show their current department and their previous department. How can I show the previous department?
There is a position history table that shows all the departments that an employee has been to. So basically the last entry in that table shows the current department ,and the entry before the last shows the previous department. How can I show the entry before the last in my report?
Thanks
I assume the records have a PersonID and an appointment date in each record?
ASKER
Yes they do
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!