Mark, IT WORKS!!!! I never would have figured that out and now I've learned a new "trick" on how to query data. Now I just have to add all of the other columns to it and then duplicate it again so I can add an additional clause to the group by.

Thank you so much for taking the time to help me figure this out.