Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Expression has the wrong amount of arguments
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.
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 :-)
8/22/2022 - Mon
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
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
You are a legend Gustav! Thank you so much. :)
You are welcome!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent