Solved Convert this excel formula to work in query (1 Viewer)

[CJ_London]

@Pat Hartman - you have a extra )

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

 

[Number11]

@Pat Hartman - you have a extra )

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

STILL DOES NOT WORK

 

[Pat Hartman]

Did you remove the extra ")"?

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

 

[Gasman]

23 posts in and all we get is 'It does not work'

Upload a sample DB so someone can get it to work for you.

 

[Pat Hartman]

Instead of RBAR we have PBAP

 

[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

 

[Pat Hartman]

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.

 

[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","")

 

[Pat Hartman]

I guess we can assume that the data type is text.

Glad your problem is solved