a query to bring us sort and sum at t he same time

[ariansman]

We have the following table:

ID​	Staff​	ItemName​	Price​	Qnt​	Cost​
1​	John​	Book​	5​	3​	15​
2​	Mori​	pencil​	6​	7​	42​
3​	Tom​	Book​	7​	4​	28​
4​	Tom​	paper​	10​	6​	60​
5​	Mori​	paper​	10​	3​	30​
6​	John​	pencil​	6​	2​	12​
7​	John​	Book​	5​	1​	5​
8​	Mori​	paper​	10​	8​	80​
9​	Mori​	pencil​	6​	4​	24​
10​	Mori​	ink​	12​	3​	36​

Can I get the following result in a query?

Staff	Cost​
John	32​
Mori	212​
Tom	88​

I hope i find a solution for this in this forum.
thank you

[Welshgasman]

Crossposted with replies https://www.access-programmers.co.uk...-query.319466/

[CJ_London]

use an aggregate query (in query design, click the sigma symbol - totals), group and sort on the staff column, sum the cost column, you should end up with something like

SELECT Staff, sum(Cost) as ttlCost
FROM myTable
GROUP BY Staff
ORDER BY Staff

[Welshgasman]

use an aggregate query (in query design, click the sigma symbol - totals), group and sort on the staff column, sum the cost column, you should end up with something like

SELECT Staff, sum(Cost) as ttlCost
FROM myTable
GROUP BY Staff
ORDER BY Staff

Already been advised that in the other forum.

[CJ_London]

so I see - complete waste of my time and effort and after some 200 posts on this and the other forum, needs to ask the question?

OP would be well advised to read this http://www.excelguru.ca/content.php?184

Will go on my ignore list as this has really annoyed me

[Welshgasman]

so I see - complete waste of my time and effort and after some 200 posts on this and the other forum, needs to ask the question?

OP would be well advised to read this http://www.excelguru.ca/content.php?184

Will go on my ignore list as this has really annoyed me

You have actually called him out in it in the past, as he has done it several times.
https://www.accessforums.net/showthr...ht=crossposted

[ariansman]

Already been advised that in the other forum.

Man, I understand your rules, sorry if i violated it. I am simply looking for an answer. I desperately need it.
I will only post on this forum next time.

[ariansman]

it worked. thank you man