Hi, I have a simple query I can't get my head around.
I have a snapshot of our workforce from abut 6 months ago, and one from now. I need to know the changes that have taken place in that six months.
Unfortunately the post->person is not a one-to-one relationship. We have a few hundred people in one post number etc. I thought about adding post number to person number to get a unique identifier but I can't get that to produce the output I'd like.
I basically need to know 1) Where a postholder has changed 2) where a post os no longer used 3) where a new post has been created
I attach an example of the output I'd like.
Thanks in anticipation,