Expression u entered has a function containing the wrong number of arguments

[sdc1234]

Here is code that keeps on giving me the same error msg Expression u entered has a function containing the wrong number of arguments can anyone help figure out whats wrong with this code




test: IIf([EMI_Courses_ALL]![Location]="CANCELLED",IIf([Emi_Course_All]![Off Campus Beds]=IsNull(IIf([EMI_Courses_ALL]![Type]="E",1200,1800)*([EMI_Courses_ALL]![Students Scheduled]+[EMI_Courses_ALL]![Instructors]),([EMI_Courses_ALL]![Students Scheduled]+[EMI_Courses_ALL]![Instructors]-[EMI_Courses_ALL]![Off Campus Beds])*1200+[EMI_Courses_ALL]![Off Campus Beds]*1800),0)

v/r
novice

[orange]

Which part of the error message is confusing?

error msg Expression u entered has a function containing the wrong number of arguments

Did you look up the IIF() syntax and examples on Google? What part is confusing?

If() or This one

[June7]

Simplify for readability. The table name is not need if the field names are not duplicated in the query. Follow the parens and commas. Parens must be in pairs. Since there are 11 parens, one is missing.

test: IIf([Location]="CANCELLED", IIf([Off Campus Beds]=IsNull(IIf([Type]="E",1200,1800)*([Students Scheduled]+[Instructors])), ([Students Scheduled]+[Instructors]-[Off Campus Beds])*1200+[Off Campus Beds]*1800, something),0)

That expression says:

If Location = cancelled then if OffCampusBeds Is Null then this calc else something, otherwise Location <> cancelled and return 0

I have no idea if the new paren is correctly placed for what you want.

Possibly you really want Nz instead of IsNull.

[Xipooo]

This is the proper way to use an IIF statement.

IIF(countNestedIIFs(currentProcess) > 1, refactorApplication = True, refactorApplication = False)

Notice the first parameter returns a boolean value of true or false. When the parameter returns as true then the code in the second parameter is returned. If the first parameter returns a value of false then the third parameter is returned.