Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

You tried to execute a query...

Status
Not open for further replies.
patriciar

patriciar

Technical User
Mar 31, 2004
3
US
What does this error message mean and how do I correct it:
"You tried to execute a query that does not include the specified expression '....' as part of an aggregate function."
 
Sort by date Sort by votes
You have a GROUP BY clause that does not include ALL the non aggregate fields of the SELECT fields list.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
447
dhookom
dhookom
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
2K
ameedoo3000
ameedoo3000
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
387
SkipVought
S
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
355
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
2K
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top