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
 

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

Similar Threads

IIF Statement to return multiple values for a field - JohnW 3
multiple outcomes 7
Returning the existing value 2
Query to text file cuts my leading zeros off. 4
Returning A Varibale from a query 1
Create a yes no message on a command button on click 0
Strip $ and , from a Text field 4
Return only the numbers contained in a field 6

Top