group by and fields that r not part of aggregate function

  • Thread starter Thread starter kato
  • Start date Start date
K

kato

I face a problem when i try a simple query on my access
database.
the query that i try to execute is
select price,item,sum(quantity) from
store_in
group by (item);

and i get that error message

you tried to excute a query that dosen't include the
specified expression 'price' as part of an aggregate
function

i tried many things and it doesn't work out
i hope that you would help me in this problem
thx for ur help
 
Kato,

Does it give you what you want if you do it like this...
SELECT price, item, Sum(quantity) FROM store_in
GROUP BY (item, price)
 
Back
Top