Sum up rows, based on same name or ID

[harcsakutya]

Hello,
In table 0020 I’ve several values which has same name of (Anyag) but different amount(Szab.felhasz). So anytime the value "anyag" is equal, has to be to sum up based on "Anyag" (material) these. For eg.: 21+224=245. What formula or technic required?

0020
Anyag	RakH	Sarzs	Szab# felhaszn#
21-130-0354	0020	4020469	21
21-130-0354	0020	4020560	224

<thead>
</thead><tbody>
</tbody>

https://drive.google.com/file/d/0B9KaCF56CJ3Qell6X0RaTnVuN2c/view?usp=sharing

Thanks, in advance

 

[healey21]

Create a query and use the totals icon, then select to group on the Anyag field and Sum on the Szab.felhasz

 

[harcsakutya]

Create a query and use the totals icon, then select to group on the Anyag field and Sum on the Szab.felhasz

I tried nothing changed. This is one single table. Yes I made a query and marked the checkbox under Szab.felh. all of the rest of three column marked as a Group by which I think no make sense....

 

[apr pillai]

1. Remove columns RakH & Sarzs from the Query.
2. Group By Anyag column and put Sum under Szab.felhazs column

 

[harcsakutya]

Yes it's works, but the problem is I've already queries on column Rakh & Sarzs. So after this records has been filtered, I need the total value based on column Anyag if data is same or duplicates.

img.: https://drive.google.com/file/d/0B9KaCF56CJ3QZ3dVVjRVSEx6eEE/view?usp=sharing

Thanks

 

[alansidman]

This is what is meant by the discussion above

SELECT [0020].Anyag, Sum([0020].[Szab# felhaszn#]) AS [SumOfSzab# felhaszn#]
FROM 0020
GROUP BY [0020].Anyag;