Using aggregate functions in a query. When I click run I get the

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using aggregate functions in a query. When I click the run button I get the
following message: Cannot group on fields selected with'*'. What do I need
to do? The fields are not selected with '*' that I click? Thanks
 
You query properties might have Output All Fields set to Yes. If you can't
figure this out, view the sql and look for "*".
 
You must log in or register to reply here.

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't use an aggregate function in an expression? 4
Opinion about aggregates 8
field not part of aggregate function 6
Aggregate calculations on calculated query fields? 6
Aggregate function 2
Can not group on fields selected with '*' 2
subquery in group by query 3
aggregate functions 2

Back
Top