asked on 1/29/2019

Expression has the wrong amount of arguments

Hi

I am having some trouble with the below expression in a query. I am trying to get the average of three fields which allows for zero's.

ACWLW: ([RELTTMALW]+[AOLTTMALW]+[WTMALW])/IIf((-([RELTTMALW]<>0)-([AOLTTMALW]<>0)-([WTMALW]<>0))

It is telling me that The Expression you entered has a function containing the wrong number of arguments.

It has been a long day and I just cannot see it!! Could somebody please enlighten me :-)

Thanking you

Microsoft Access

Last Comment

Gustav Brock

1/30/2019

Daniel Pineault

1/29/2019

IIF() expects 3 input variables, the criteria to test for, what to do if it is TRUE, what to do if it is FALSE.
If you explain what should be happening, we can try to further help.

Also, ypically I would use Nz([FiledName], 0) to always ensure there is a numeric value being returned just in case a field is empty, Null which could cause errors to be thrown.

ASKER CERTIFIED SOLUTION

Gustav Brock

1/29/2019

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ajaeclarke

1/29/2019

ASKER

You are a legend Gustav! Thank you so much. :)

Gustav Brock

1/30/2019

You are welcome!