Sow I have hmm the name Jan and the name Bert
Jan order 2 products and Bert 1.
Jan's total prise must be calculated. and that from Berts two.
I have to 2 tables one tabl is produkten and the other is verkoop.
Table Produkten contains: ProduktID, ProduktNaam, Prijs.
Table Verkoop contains : BestelId,ProduktID,Naam,Aantal.
No I made an extra field with AS that's TotaalPrijs
TotaalPrijs is Prijs*Aantal
No I need to count Totaal Prijs (SUM)Totaal prijs where Naam=Verkoop.Naam
Something like this it has to be. It is a kind off difucult to explane. But please try to help me