Solved Convert this excel formula to work in query

[Number11]

Did you remove the extra ")"?

Are you EVER going to tell us what data type we are working with?

yeah i have

=IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")

 

[Number11]

Ill export it into excel and use my original formula thanks anyway

 

[GPGeorge]

I'm going to hazard a guess. The OP doesn't KNOW what the datatype is, or even what is meant by the term, and rather than ask what that means, continues to ignore the question. It's a winning strategy in some situations, where ambiguity is acceptable.

 

[Number11]

And we STILL do not know what datatype the fields are

It is really hard to help you @Number11 when you can't answer questions. If you read the text you quoted, you should see TWO questions. NOT just one. We've given you solutions for BOTH Boolean and sting values. One of them should have worked.

thanks this worked i had to rebuild the database and its all working now thanks so much for all your help
=IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")