That did it. Thanks!!

By Jove Frank I think you've got it! I see the join change but I also noticed when I changed my code that without the alias' I get an error....

Mr. Johnson,

Thanks for the suggestion! I've tried it and I'm still getting "GROUP BY expressions must refer to column names that appear in the select list". I have to admit that...

Hello and thank you for the suggestions. You are absolutely correct about my error. My code, as posted, results in an error stating that the group by expressions must refer...