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