Share via

Access Query Error

Anonymous
2019-08-27T06:24:59+00:00

Hi, I am getting an error message "Your query does not include the specified expression 'ID' as part of an aggregate function". Please suggest a fix

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-27T18:57:26+00:00

    That error normally happens when you have created a query with "Totals" (your data is grouped) and one field does not have a total designation.  Check to see that each field has a Group By, Sum, Expression, etc.

    Hope this helps,

    Jackie L

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-08-27T06:54:20+00:00

    ciao RaiyanK,

    some more details please, otherwise we cannot help.

    post here your sql predicate, so we try fixing it.

    Explain better what you would need to achieve, even if the message given is clear about the error.

    thanks and ciao, Sandro.

    Was this answer helpful?

    0 comments