Conditional if 0 or 1 return text value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I know its in this thread somewhere but I can't find it.
I have a query that return a 1 or a 0 for a given field. I would like it to
return a text value:

iff([pre sale or Post sale]=1, "Post-Sale","Pre-Sale")

This example generates Iff error. What am I missing please?
Thank you,
Vadimbar
 
Back
Top