Query Error Aggregate Function

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

Guest

I have Built a query as a select query then used the total button to get what
I need.
When use the Total Button again to look at the Data that way All the Fields
that where simply left as groupings Get the error message. "You tried to
execute a query that does not include the specified expression 'Player' as
part of an aggregate funcion". and I can't run the query without the Totals
Button Pushed.
 
If the field does not contribute to grouping or aggregate, then it can not
be added to the query.
 
Thank You for the Re

But......I wanted it to.

[MVP] S.Clark said:
If the field does not contribute to grouping or aggregate, then it can not
be added to the query.
Click to expand...
 
You probably have a calculated field that is using one of the aggregate
functions in the calculation.

Please copy and post the SQL of your query and perhaps someone can
suggestion the necessary modification.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
 
Thank you John Spencer! I had the same problem, and as soon as I read your
first sentence, I knew what was going on. "Sum" was in one of my expressions!
 

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

Aggregate calculations on calculated query fields? 6
Access Query problem 1
can't use an aggregate function in an expression? 4
subquery in group by query 3
Invalid use of null in query expression 3
Aggregate function 4
aggregate function error 1
aggregate function error 7

Back
Top