iif problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey there

If an employee is required to pay labour insurance then it is called by a
function else the value is set to 0

=Iff([Pay_Lbr_Ins]=True,Ins_Lookup([Labour_Insurance_Subtotal]),0)

Gives an error. The function works fine and the controls are valid. Help
 
Hey there

If an employee is required to pay labour insurance then it is called by a
function else the value is set to 0

=Iff([Pay_Lbr_Ins]=True,Ins_Lookup([Labour_Insurance_Subtotal]),0)

Gives an error. The function works fine and the controls are valid. Help
Click to expand...

what is the function returning? a string, a number, Null ............
and what is left of the = (variable type) ?

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Back
Top