IIF Result

[Guest]

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"))

 

[Guest]

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

 

[Guest]

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

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"))

 

[Guest]

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

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

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"))

 

[Guest]

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

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

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

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"))