Is there any way to prevent the query designer from adding in every single column in the query into the group by clause when there is a Sum() calc field?
All columns in the "select" clause that are not an aggregate function need to be in the "group by" clause. Otherwise you will have an invalid query and will likely get an error from your DB.
Comments
All columns in the "select" clause that are not an aggregate function
need to be in the "group by" clause. Otherwise you will have an invalid
query and will likely get an error from your DB.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com