Revision history [back]

The criteria builder in a database query can be utilized to sort information by two columns by following these steps:

1. Open the database query and select the table you want to use.

2. Click on the "Sorting and Grouping" button in the menu.

3. In the "Sorting and Grouping" dialog box, click on "Add a Sort" and select the first column you want to sort by.

4. Click on "Add a Sort" again and select the second column you want to sort by.

5. Choose the sort order for each column (ascending or descending).

6. Click "OK" to save the changes.

Now the information in the query will be sorted by the two columns you selected, with the first column taking precedence over the second. This means that if there are ties in the first column, the information will then be sorted by the second column.