Hi dkinley, thanks for that.
I have decided to use the "select case". It's gotten me close enough, except one thing, perhaps you or anyone can offer more help?
Here's my query now:
Now There's an employee by the name "Sally Thompson" that has 2 archived positions. i.e. two positions in the...