Conditional if 0 or 1 return text value


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top