Does not include the specified expression as part of an aggregatefunction

  • Thread starter Thread starter Beejer
  • Start date Start date
B

Beejer

Running Access 2003 on Windows XP

I'm starting a new structure parallel to a current database. The table
are fully linked (no local tables) and I'm trying to create a simple
query and I keep getting this message.

The current query has one table to it, the general idea is to
calculate consumption of raw materials in production.

Fields:
- Product Code (Text) // These are alphanumeric codes.
- Inventory deductions // Numeric

I'm trying to sum, min and max the deductions. My formula : "Total :
Sum([Inventory deductions]) // Low : Min([Inventory deductions]) //
High : Max([Inventory deductions])

When I try to run the query, "Does not include the specified
expression as part of an aggregate function" pops up. I never had this
issue before.

Anybody can enlighten me on what is going on?
 
Running Access 2003 on Windows XP

I'm starting a new structure parallel to a current database. The table
are fully linked (no local tables) and I'm trying to create a simple
query and I keep getting this message.

The current query has one table to it, the general idea is to
calculate consumption of raw materials in production.

Fields:
- Product Code (Text) // These are alphanumeric codes.
- Inventory deductions // Numeric

I'm trying to sum, min and max the deductions. My formula : "Total :
Sum([Inventory deductions]) // Low : Min([Inventory deductions]) //
High : Max([Inventory deductions])

When I try to run the query, "Does not include the specified
expression as part of an aggregate function" pops up. I never had this
issue before.

Anybody can enlighten me on what is going on?
Click to expand...

I was getting so desperate when I posted this, nothing was working...
so I got up and walk to coffee machine and back... found my mistake.

Solution was pretty simple that I couldn't even see it. I removed "
Inventory deductions" for the query to concentrate on "Product code".
Grouped "Product Code" only with the Group by feature and ran the
query with only the sum expression ** not grouped** and no message.

I will push this further... and sorry for not signing earlier.

Beejer
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
Back
Top