Only display fields if field matches criteria

I'm trying to build a query where the field only displays "Show" if
the field matches a string.

For example, I have about 20 fields and each of them has the check box
to 'Show'. I only want the field to show if the text "Traffic ↔
PreCon" is in the field. I tried doing if statements and I found that
if the first field doesn't match this criteria, then none of them show
up. "Traffic ↔ PreCon" could be in field 3 or 13. I just want to
filter through the fields and only show the ones that have that
string.

Any ideas?

I'm not sure I'm visualizing your data yet...

Are you saying that the string you are looking for could be in one of
several different columns/fields? If so, then there's a good chance you
have a ... spreadsheet, not a relational database table!

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"gab1972" wrote in message
...
I'm trying to build a query where the field only displays "Show" if
the field matches a string.

For example, I have about 20 fields and each of them has the check box
to 'Show'. I only want the field to show if the text "Traffic ?
PreCon" is in the field. I tried doing if statements and I found that
if the first field doesn't match this criteria, then none of them show
up. "Traffic ? PreCon" could be in field 3 or 13. I just want to
filter through the fields and only show the ones that have that
string.

Any ideas?