group by and fields that r not part of aggregate function

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
 
S

Steve Schapel

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)
 
Top