I have a database that contains people and a related table that has their flight information in it. There are reports that need to be run where I pull information regarding their originating, arrival or departure flight information. I have created a field which tells us what type of field it is. It contains words originating, arrival or departure, with direct flights the field could contain both originating and arrival.

This is the calculation I am using to pull the name of the airline for the arrival flight. If the field contains both originating and arrival it doesn't work. Is there a different operator or calculation that I can use to evaluate the entire field for a particular word?

Case ( type_of_flight ="Arrival";airline;"" )

The other option is to make arrival, departure, and originating all their own fields.

Any suggestions?

Perhaps I'm missing something. How are you showing both "Arrival" and "Originating" in the same field? Are you allowing the user to type in the value rather than have a value field? If so, you are leaving the data exposed to all kinds of errors in spelling and the way the data is separated. Do you mean you are looking for a way to determine either/or ? See below.

Case (

type_of_flight ="Arrival";airline;

type_of_flight ="Originating";airline;

"" )

It can be both the originating and arrival if it is a direct flight with no connections.

I think I just need to make Originating, Arrival and departure as three different fields. Not the cleanest way to do it but it will work.

Try the PatternCount() function.