Does not include the specified expression as part of an aggregatefunction

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?

On Dec 22, 9:50*am, Beejer wrote:
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?

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Beejer" wrote:

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