the expression you entered has a function containing the wrong num

G

GM7

How can I combine these 2 IIf statements withour getting the error message in
the subject line?

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,[SemiPrice],
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

The first part of the IIf statement works fine.
 
K

KARL DEWEY

Try this --
Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))
 
J

John Spencer MVP

Perhaps what you want is the following:

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
F

fredg

How can I combine these 2 IIf statements withour getting the error message in
the subject line?

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,[SemiPrice],
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

The first part of the IIf statement works fine.
Click to expand...

The syntax for a multiple IIf statement is:

IIf(Criteria1 = True,TruePart1,IIf(Criteria2 = True, TruePart2
,FalsePart))


Final Price: IIf([Premium Package]=True And [SemiPrice]< 936,936,
IIF([Premium Package]= False And [SemiPrice]<780, 780,[SemiPrice]))
 

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

Please Help! The Expression you entered is too complex 0
iif statement what is wrong with this expression 2
Nested IIf expression 1
Function containing the wrong number of arguments 5
IIF Statements in update query 5
Expression error 2
Getting error: "The expression you entered is too complex" in quer 6
Multiple IIf's 6

Top