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