Expression with wrong number of arguments??

N

neil_val

Hi, please can you help me see the error?

This is my query qryChartTest

CountOfEmployeesName PMonth Total Hours ContractualHrs HrsToDo
OT40+ OT50+
1 Mar 07 258
200 205

I am trying to define the hours that are over the ContractualHrs but
less than HrsToDo
and then the same for Hours over HrsToDo.

Sum(IIf([Total Hours]>([ContractualHrs]*[CountOfEmployeesName]),[Total
Hours]-([ContractualHrs]*[CountOfEmployeesName])),IIf([Total
Hours]>[HrsToDo],[HrsToDo]-([ContractualHrs]*[CountOfEmployeesName])),
0)

Thanks
 
D

Duane Hookom

We can't "see the error" when we can't see the result and don't know the
expected values.

Could you provide some sample values for significant field and the values
you expect to return?
 
Top