David and Genke,
I was using GROUP BY totally wrong. I looked at w3 schools and now I see more of what its purpose is. I need some practice on SQL. I don't use it all of the time and then I forget parts.
When in Florida, Don't Tampa with the code. I made this up.