IIF Result

M

Matt

Thanks in advance for your assistance.

I am trying to create an IIF statement that will return Text AND a field
value. What I have input so far only returns the Text. Any suggestions?

Quote: IIf([Actual Quote] Is Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))
 
K

KARL DEWEY

Somehow I am lost reading this. Please post some sample data and results now
and what you would like to see.
 
M

Matt

I am getting the following results:

Quote: Due

What I would like to see is:

Quote: Due 7/21/2007 with the date being the field [Actual Quote]

--
Thanks..Matt


KARL DEWEY said:
Somehow I am lost reading this. Please post some sample data and results now
and what you would like to see.
--
KARL DEWEY
Build a little - Test a little


Matt said:
Thanks in advance for your assistance.

I am trying to create an IIF statement that will return Text AND a field
value. What I have input so far only returns the Text. Any suggestions?

Quote: IIf([Actual Quote] Is Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))
Click to expand...
Click to expand...
 
O

Ofer Cohen

The first criteria is wrong, you combinning the text to the field when it''s
Null and this is why it return only the string "Due" with no date (that is
Null)
If you change it to "Is Not Null", then you'll have a problem with the next
criteria that will compare a Null value.
Please explain what you are trying to achieve

Quote: IIf([Actual Quote] Is Not Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))

--
Good Luck
BS"D


Matt said:
I am getting the following results:

Quote: Due

What I would like to see is:

Quote: Due 7/21/2007 with the date being the field [Actual Quote]

--
Thanks..Matt


KARL DEWEY said:
Somehow I am lost reading this. Please post some sample data and results now
and what you would like to see.
--
KARL DEWEY
Build a little - Test a little


Matt said:
Thanks in advance for your assistance.

I am trying to create an IIF statement that will return Text AND a field
value. What I have input so far only returns the Text. Any suggestions?

Quote: IIf([Actual Quote] Is Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))
Click to expand...
Click to expand...
Click to expand...
 
M

Matt

It is embarassing to know that I selected the wrong target! Thanks for the
extra set of eyes. Made the change and now it works.
--
Thanks..Matt


Ofer Cohen said:
The first criteria is wrong, you combinning the text to the field when it''s
Null and this is why it return only the string "Due" with no date (that is
Null)
If you change it to "Is Not Null", then you'll have a problem with the next
criteria that will compare a Null value.
Please explain what you are trying to achieve

Quote: IIf([Actual Quote] Is Not Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))

--
Good Luck
BS"D


Matt said:
I am getting the following results:

Quote: Due

What I would like to see is:

Quote: Due 7/21/2007 with the date being the field [Actual Quote]

--
Thanks..Matt


KARL DEWEY said:
Somehow I am lost reading this. Please post some sample data and results now
and what you would like to see.
--
KARL DEWEY
Build a little - Test a little


:

Thanks in advance for your assistance.

I am trying to create an IIF statement that will return Text AND a field
value. What I have input so far only returns the Text. Any suggestions?

Quote: IIf([Actual Quote] Is Null,"Due " & [Actual Quote],IIf([Actual
Quote]>[Target Quote],"Late","On Time"))
Click to expand...
Click to expand...
Click to expand...
 
Top