aggregate function???

  • Thread starter Thread starter Jill Waters via AccessMonster.com
  • Start date Start date
J

Jill Waters via AccessMonster.com

I keep getting "you tried to execute a query that does not include the
specified expression 'orderId' as part of an aggregate function.

what the heck does that mean?
 
It means what it says. If you paste your SQL into a reply, someone might be
able to help you sort this out.
 
Jill Waters via AccessMonster.com said:
I keep getting "you tried to execute a query that does not include the
specified expression 'orderId' as part of an aggregate function.

what the heck does that mean?
Click to expand...

It means exactly what it says.

When you use an aggregate function in a query (e.g. Max) then every field
your query returns has to be EITHER the result of an aggregate function OR
has to be included in a GROUP BY clause. It's simple logic, you can't
aggregate/group by some fields but not others.

For more specific help, you'll have to post the SQL for the query.
 
I understand.
I'm trying to get a list of invoices where only some have special products.
My query will only give me the results where I have the special products so
I was trying to get all invoices and put "0" or something in the rest.
 
Back
Top