SELECT SUM(orders.quantity) AS num, fName, surnameFROM authorINNER JOIN book ON author.aID = book.authorID;I save acquiring the error message: "you tried to execute a query that does not incorporate the mentioned expression "fName" as part of an accumulation function. What execute I do?


*

*

The error is bereason fName is had in the SELECT list, yet is not had in a GROUP BY clausage and also is not component of an aggregate feature (Count(), Min(), Max(), Sum(), etc.)

You deserve to deal with that problem by consisting of fName in a GROUP BY. But then you will confront the same concern through surname. So put both in the GROUP BY:

SELECT fName, surname, Count(*) AS num_rowsFROM author INNER JOIN book ON writer.aID = book.authorID;GROUP BY fName, surnameKeep in mind I provided Count(*) wright here you wanted SUM(orders.quantity). However, orders isn"t included in the FROM section of your query, so you should incorporate it before you can Sum() among its areas.

You are watching: Your query does not include the specified expression as part of an aggregate function

If you have actually Access accessible, develop the query in the query designer. It have the right to help you understand what features are possible and also use the correct Access SQL syntaxation.


*

I had a similar trouble in a MS-Access query, and also I resolved it by altering my identical fName to an "Expression" (as opposed to "Group By" or "Sum"). So long as all of my fields were "Expression", the Access query builder did not require any kind of Group By clausage at the finish.
*


*

GROUP BY can be selected from Total row in query architecture see in MS Access.If Total row not presented in design check out (as in my case). You can go to SQL View and add GROUP By fname etc. Then Total row will certainly immediately show in style check out.You have to select as Expression in this row for calculated fields.


*

Thanks for contributing a solution to Stack Overflow!

Please be certain to answer the question. Provide details and share your research!

But avoid

Asking for aid, clarification, or responding to various other answers.Making statements based upon opinion; back them up via references or personal suffer.

See more: 40 To 1 Vs 50 To 1 Vs - Which Has More Oil 40/1 Or 50

To learn more, watch our tips on writing great answers.


Article Your Answer Discard

By clicking “Blog post Your Answer”, you agree to our regards to business, privacy policy and also cookie plan


Not the answer you're looking for? Browse various other inquiries tagged sql ms-access or ask your own question.


Your Query does not encompass the expression 'Open Amount' as part of an aggeprice attribute - MS Access
I am getting: "You tried to execute a query that does not incorporate the stated expression 'OrdID' as component of an aggregate function. How perform I bypass?
Access Query + your query does not incorporate the mentioned expression 'TimeID' as part of the accumulation function
UNION Query Error - "You have tried to execute a query that does not inlude the specified expression..."
Tried to execute a query that does not encompass the stated expression 'StaffDetails.StaffID' as component of an accumulation function
MS-Access - You tried to execute that does not include the stated expression 'Quantity' as component of an aggregate feature
Access Update Query: Query does not encompass the mentioned expression as component of an accumulation attribute
site design / logo design © 2021 Stack Exreadjust Inc; user contributions licensed under cc by-sa. rev2021.9.17.40238


Your privacy

By clicking “Accept all cookies”, you agree Stack Exadjust deserve to store cookies on your tool and discshed information in accordance through our Cookie Policy.