Hello everyone
in the attached database, query qryProva will produce two records, one with costi_diretti, one with costi_indiretti for the same commessa (project):
ID_commessa Fatturato costi_diretti costi_indiretti PROVA A_1 300 10 PROVA A_1 300 50
I would like to have only one record as in the following example:
ID_commessa fatturato costi_diretti costi_indiretti PROVA A_1 300 10 50
Is it possible? Thanks a lot for your help.