Help! how to sum by categorie

hello there, i.ve got a big issue, I have one base with multiple tables, in one table i have

proyect # (a number to identify each proyect)
requirement # (number to identify each purchase made for the proyect)
concept (single selection to identify the type of service or good i.e construction, services, labor etc)
value (amount $ of the requirement)

Now in another table in the same base, i want to sumarize the total amount paid for the proyect in each concept.

ie. proyect # …concept (labor)… total amount $ (1.000) when this total amount is the sum of all the concepts named labor in the other table.

i dont knwo how to do it, please help

You can’t do it in another table without going through the process of manually linking records. The easiest way to do it would be to just use your existing table. Group your records appropriately in the first table, and use the summary bar to see your totals.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.