i have made the folowing data base, and in report "lucrari neachitate", i have trouble with calculated text box.
so, i have the text box named "total lucrari" and it supose to be the total of text box named "pret lucrare", but it calculates all wrong.
amean, if i have more then one pay for each lclient, that "lucrari neachitate" text box, calculates "pret lucrare" multiplied with number of pays.


how can i obtain a correct rezult?