Thanks Mark. I understand this now. I realized that I had to add fields to group by clauses if one already existed, just didn't realize that it was a requirement in some cases to have one.

thank you all very much!