aggregate function???

[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?

 

[Duane Hookom]

It means what it says. If you paste your SQL into a reply, someone might be
able to help you sort this out.

 

[Brian]

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 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.

 

[Jill Waters via AccessMonster.com]

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.

 

[Duane Hookom]

Brian and I both suggested that you post the SQL view of your query. You
didn't.