How to Use OR Criteria to Query on Alternate or Multiple Conditions?
To see data when either at least two interchange criteria are fulfilled, utilize the or criteria pushes in the Access question outline lattice. 1. Open the table that you need to use as your question source and on the Create tab click Query Outline. 2. In the Query Designer, select the table, and double tap the fields that you need showed in the question comes about. 3. Include your first measure in the Criteria push. 4. Include the substitute criteria in the or push and in the event that you have in excess of one utilize the unfilled columns beneath, and click Run. 5. Press CTRL+S to spare the question. Do you want to install office 365 : office setup install Another case of the OR criteria: Discover representatives who work in the Chicago branch office OR representatives whose birthday falls on a particular date: 1. The City standard is indicated in the Criteria push. 2. The BirthDate standard is indicated in the or push. Criteria indicated in the C...