sum in forms

  • Thread starter Thread starter SHR
  • Start date Start date
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
 
Sorry
my 2nd line is
TOTAL =
SUM(TrueFalse(2000>[plafond];[plafond];2000-[plancher])* [txpat])
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Aggregate Function Error 0
store a value of a text box that calculates data into a data sourc 2
Count Function 6
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Sum in Main Form from Subform 7
Running Total & DLOOKUP 4
How do I calculate a sum between a combo box and an input box? 2

Back
Top