You may want to use a column in the criteria used to determine which records are returned, without actually displaying that column's information in the result set. You can do this by adding the column to the query and setting its criteria, and then hiding the column from the query result set.
To hide any column from the query result set, clear the check box in the Output column. To display the column, select the check box in the Output column.
In the example below, the query will return data where the company name contains both "Market" and "Food". However, it is not necessary to display the same CompanyName data in two columns in the query result set, so only one Output check box has been selected for this value.
More:
Setting an alias for the column
Adding criteria for the column