Thanks for the help!  All I had to do was add an ORDER BY statement at the end, and I also made sure that all my columns were selected, instead...

I'm still getting the same error. "You tried to execute a query that does not include the specifed expression 'NursingHomeName' as part of an aggregate function."

I'm guessing that there has...