Change Over Report?

[Ddempsii]

Hello all, I'm looking to make some sort of Change Over Report. What I want is basically a list of changes from last month. I have a staffing table where multiple people change managers every month. I have tried making a report with all the information from last month to this month, but I don't need all of the info for everyone. Some people haven't changed managers. Is there a way to get a list of only the people who are different? If any questions please let me know

[June7]

This requires each record to consider value in another record of same table as criteria for its retrieval. Requires a nested subquery http://allenbrowne.com/subquery-01.html#AnotherRecord or domain aggregate function.