Query with Multiple "ORs"

[Lynn63]

I have a table called Employees. It has approx. 20 fields and roughly 4000 records. Any of they fields may contain a the phrase "data not available." I need to create a query that picks out all records that have the "no data available" phrase in any of the 20 fields. My first thought was to use the query builder and do "OR." Problem is it only allow me space to do about five fields. I also thought of creating 20 queries -- one for each field. There has to be a better way. Does anyone have any insight? Thanks...

 

[Rich]

Your structure sounds as though it is not normalised, post an example of your table structure and the reason for storing "data not available" in any of the fields