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?