Iff Function

  • Thread starter Thread starter Leo
  • Start date Start date
L

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
 
oops!
I promise I will be careful from now on...instead of abusing the discussion
group.

Thank you
Leo

KARL DEWEY said:
Try IIF ----
--
Build a little, test a little.


Leo said:
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
Click to expand...
Click to expand...
 
Back
Top