Expression with wrong number of arguments??

  • Thread starter Thread starter neil_val
  • Start date Start date
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
 
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?
 

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

IIF statement query problem - please help... 1
How to sum in an append query 1
Calculations being multiplied 1
Access My Expression Contains Wrong number of arguments 0
Slow Crosstab Query 2
Calculating hours on a timeclock form 7
Access Query problem 1
Expression to count hours for present day 6

Back
Top