If a query contains multiple conditional statements, you can move any statement up or down to change the order in which the conditions are applied to the query.
To reorder a conditional statement
Click the Conditions tab.
Select a statement in the grid.
Click Move Up or Move Down.