sum in forms

S

SHR

Hi,

can you tell me please why in my form this line is wrong :
TOTAL =
SUM(TrueFalse(Form!F_SALARIE2!salbrut>[plafond];[plafond];Form!F_SALARIE2!sa
lbrut-
[plancher])* [txpat])

and this second line is good
TOTAL =
SUM(2000>[plafond];[plafond];2000-[plancher])* [txpat])

whereas Form!F_SALARIE2!salbrut = 2000

thanks
 
S

SHR

Sorry
my 2nd line is
TOTAL =
SUM(TrueFalse(2000>[plafond];[plafond];2000-[plancher])* [txpat])
 
D

Damien McBain

SHR said:
Sorry
my 2nd line is
TOTAL =
SUM(TrueFalse(2000>[plafond];[plafond];2000-[plancher])* [txpat])

SHR said:
Hi,

can you tell me please why in my form this line is wrong :
TOTAL =
Click to expand...
SUM(TrueFalse(Form!F_SALARIE2!salbrut>[plafond];[plafond];Form!F_SALARIE2!sa
lbrut-
[plancher])* [txpat])

and this second line is good
TOTAL =
SUM(2000>[plafond];[plafond];2000-[plancher])* [txpat])

whereas Form!F_SALARIE2!salbrut = 2000

thanks
Click to expand...
Click to expand...

Are any of the fields referred to already calculated? You can't use calc'd
fields in other calc'd fields on a form

I find it easier to do the calcs in queries rather than on forms.
 
Top