Every time I run the query, I get a message, which is (translated) The query has no gave up expression 'CustomerID'as part od a statistic function. Who helps?
Scott Axton
@Reply 4 years ago
I apologize but the translation doesn't come across in a meaningful interpretation.
Are you using your own database or the one from the class?
Would you please post a picture of your query in the design mode so we can try and help you out?
Wander MulderOP
@Reply 4 years ago
Wander MulderOP
@Reply 4 years ago
I use my own made database, but in version 365. The text (translated) is "You can't group fields selected with *.
Kevin Robertson
@Reply 4 years ago
What is the SQL behind your query?
Wander MulderOP
@Reply 4 years ago
SELECT CustomerT.State, Sum(CustomerT.CreditLimit) AS SomVanCreditLimit, Avg(CustomerT.CreditLimit) AS GemVanCreditLimit1, Max(CustomerT.CreditLimit) AS MaxVanCreditLimit, Min(CustomerT.CreditLimit) AS MinVanCreditLimit, *
FROM CustomerT
GROUP BY CustomerT.State
ORDER BY Sum(CustomerT.CreditLimit) DESC , Avg(CustomerT.CreditLimit) DESC , Max(CustomerT.CreditLimit) DESC , Min(CustomerT.CreditLimit) DESC;
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.