Iff Function

[Leo]

The following is one of the fields in a query.

Expr3: IFF(DateDiff("d",[Fld39],[Fld40])>=14,([Fld38] & " X" & "
12"),([Fld38] & " X" & " 6"))

[Fld39] and [Fld40] are datefields in the table "SCHD"
[Fld38] is a text field
I need to modify the string in that text field as above depending on the
DateDiff.

When I run the query an error message "Undefined Function in Expression"
appears.
What am I doing wrong?

Thanking you in advance
Leo

 

[KARL DEWEY]

Try IIF ----

 

[Leo]

oops!
I promise I will be careful from now on...instead of abusing the discussion
group.

Thank you
Leo

Try IIF ----
--
Build a little, test a little.

The following is one of the fields in a query.

Expr3: IFF(DateDiff("d",[Fld39],[Fld40])>=14,([Fld38] & " X" & "
12"),([Fld38] & " X" & " 6"))

[Fld39] and [Fld40] are datefields in the table "SCHD"
[Fld38] is a text field
I need to modify the string in that text field as above depending on the
DateDiff.

When I run the query an error message "Undefined Function in Expression"
appears.
What am I doing wrong?

Thanking you in advance
Leo