IF-Then Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with the following statement.
=IIf([#Days]>=2),(([MealsA]*0.75)*[#People]*[#Trips]*2),(([MealsA]*0.75)*[#People]*[#Trips]))
I keep getting "The expression you entered has a function containing the
wrong number of arguments."
Thanks for your help.
Carol
 
Since you have a close paren after the conditional test expression, Access is
interpreting your call as one parameter. Also, since multiplication doesn't
require parentheses, and you needn't enclose each parameter in parentheses,
you can simplify the call to:

=IIf([#Days]>=2,[MealsA]*0.75*[#People]*[#Trips]*2,[MealsA]*0.75*[#People]*[#Trips])

Hope that helps.
Sprinks
 
Thank you so much-works wonderful.

Sprinks said:
Since you have a close paren after the conditional test expression, Access is
interpreting your call as one parameter. Also, since multiplication doesn't
require parentheses, and you needn't enclose each parameter in parentheses,
you can simplify the call to:

=IIf([#Days]>=2,[MealsA]*0.75*[#People]*[#Trips]*2,[MealsA]*0.75*[#People]*[#Trips])

Hope that helps.
Sprinks

CCross said:
I need help with the following statement.
=IIf([#Days]>=2),(([MealsA]*0.75)*[#People]*[#Trips]*2),(([MealsA]*0.75)*[#People]*[#Trips]))
I keep getting "The expression you entered has a function containing the
wrong number of arguments."
Thanks for your help.
Carol
Click to expand...
Click to expand...
 
Carol,

By the way, as a side issue, it is not a good idea to use a # as part of
the name of a field or control.
 
Back
Top