First of all, thank you! You solved the problem I had and now the view is very close to what I am looking for. Despite the error message: The OVER SQL construct or statement is not supported.... it seems to work regardless, and, if it works, well that is what counts.
Do you think you could help me with one more minor formatting tweak?
Also,
I assumed some of the structures were not yours but the post that won't execute certainly was.
Yes, I take full blame for that. Just know that it was ignorance and not intentional laziness on my part.
------------
As for the formatting..
Is there a way to join the first and last names for each employee into a single cell? In other words, instead of four cells for two employees, it would only be two cells. Each employee name cell would countain Firstname Lastname. For example, instead of: John, Smith, Mary, Johnson. It would be: John Smith, Mary Johnson.
Once again, thank you so much!