How to find the amount through a query?

Question

Microsoft Access

There is a product (Product) and cost (Cost). Is it possible to calculate the sum of all Costs of the same Product through an Acsess query??

Answer 1

In databases, there is such a thing as grouping (group by) by a specific Product field, and at the same time, sum (Cost) is indicated in the requested fields instead of Cost.
If there are many Product values, then the result will be the sum of all Cost for each unique Product