Use the OR criteria to query on alternate or multiple conditions Open the table that you want to use as your query source and on the Create tab click Query Design. In the Query Designer, select the table, and double-click the fields that you want displayed in the query results. More items...