Query design - select fields always default to "group by"

  • Thread starter Thread starter Tripp Knightly
  • Start date Start date
T

Tripp Knightly

When designing queries (happen to be on ODBC tables) I'll select
fields and then by default "Group By" is selected under the total /
aggregation row.

Is there some setting that is causing this? By default, I'd prefer to
just be running straight-up select queries. Quite annoying to have to
deselect all those aggregation settings.

Thx
 
When designing queries (happen to be on ODBC tables) I'll select
fields and then by default "Group By" is selected under the total /
aggregation row.

Is there some setting that is causing this? By default, I'd prefer to
just be running straight-up select queries. Quite annoying to have to
deselect all those aggregation settings.

Thx
Click to expand...

Unselect the Greek Sigma icon in the toolbar.
 
What's this newsgroup coming to when
neither post mentions

"aggregation aggravation"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can not group on fields selected with '*' 2
subquery in group by query 3
Use field for selection but NOT group by? 1
Need help with Group By Total 7
Want to use Group By in union Query - solution 1
Cannot group on fields selected with '*' - bypass? 2
Aggregate calculations on calculated query fields? 6
select queries that calculate the Median base on group by 1

Back
Top