Alternate Criteria in Access 2016

This updated guide examines Alternate Criteria in Access 2016 and organizes the essential facts, background, and practical takeaways in clear American English.

You can add alternate criteria in two ways:

• Use the OR operator to combine two sets of criteria.
• Use query design grid, but instead of specifying criteria on the same line, you'll separate it into multiple rows.

Specifically invite readers to follow the content below.

Let's look at a simple example using alternative criteria in a query. First, open your Access database, then go to the Create tab and click Query Design.

In Show Table, select the table you want to query, here is tblNhanvien, double click and select Close.

In the table window, double click on the name of the field you want to appear in the query. They will be added to the design grid at the bottom of the screen. Here we choose NhanvienID, Ten, Ho, ChucDanh, Dienthoai .

Now specify replacement criteria in different rows of Ho school . When running this query, you will show employees whose last name is Bui or Vu.

Execute the query by clicking the Run command on the Design tab , you will see results like this:

If you want to apply replacement criteria in multiple fields, you add conditions to different rows for the corresponding field. Now, try adding another alternative criterion, in addition to employees with family name is Vu or Bui, we add the condition to have a job title is Translated .

Results returned:

Previous article: Parameter Query in Access 2016

Next lesson: Alternate Criteria in Access 2016