Ingen sumering når =IIf formel bruges

Not sure, but it could have something to do with the , instead of . I dont us ethe Danish , so its just a guess

reason!

=IIf([Momskode]=1;([HævetBeløb]*0,2)+([HævetBeløb1]*0,2)+([Indskudsbeløb]*0,2)+([Indskudsbeløb1]*0,2);0)

Svar til terry !
Jeg kan godt med ovennævnte kode få beregning af momsen, men jeg kan ikke sumere kollonerne med koden =Sum([Hævet i alt2]) og =Sum([Indbetalt i alt2])

stigtimer> Its getting late, but if you can wait until tomorrow I will take a look. You can send the dB to dkTeBrSa@Europe.lego.com (.com) is in the hyperlink.

stigtimer> I have now looked at your problem!
As far as I can see the problem is the following:
In the sub form footer the field [Hævet i alt2] has a control source =Sum([HævetBeløb2])
In the field [HævetBeløb2] on the detail the control source is =IIf([Momskode]=1;([HævetBeløb]*0,2)+([HævetBeløb1]*0,2)+([Indskudsbeløb]*0,2)+([Indskudsbeløb1]*0,2);0)

You are expecting the field [Hævet i alt2] to add all [HævetBeløb2] from the detail lines. But what it is actually doing is adding the field [HævetBeløb2] from the database! Which doesnt contain anything. So it is working as you want you just need to get your naming conventions in place.