Now, let’s try it. Click on the Create Tab, and then click on the Query Design Icon to display a new Query By Example (QBE) Grid. Double click the Client table selection and then click the Close Button Double click on the ClientID, FirstName, LastName, City, and State fields to add them to the grid. Add Ascending in the Sort row underneath State field on the QBE grid. the Run icon to run the query If your is correct, you will see the following dynaset. Name the query, State Sort Query. You can also sort the information you display on your list using two fields for the sort order. For example, you can sort the list in ascending order by city, and then by state. The main sort has to be to the left of the minor sort. Therefore, because we want to sort by State first and then by City, we must show the sort in the order below. Notice, we are only sorting with the second City field. We are not showing that City field in our list. Field ClientID FirstName LastName City City Client Client Client Client Client Table Sort Ascending Ascending Show x x x x x Criteria Or Or Now, let’s try it. Click on the Create Tab, and then click on the Query Design Icon to display a new Query By Example (QBE) Grid. Double click the Client table selection and then click the Close Button Double click on the ClientID, FirstName, LastName, City, State, and then add the City field again to add them to the grid. Add Ascending in the sort row underneath State field on the QBE grid. Add Ascending in the sort row underneath the second city Field on the QBE grid. Take off the show checkmark on the last City field on the QBE grid.
Now, let’s try it. Click on the Create Tab, and then click on the Query Design Icon to display a new Query By Example (QBE) Grid. Double click the Client table selection and then click the Close Button Double click on the ClientID, FirstName, LastName, City, and State fields to add them to the grid. Add Ascending in the Sort row underneath State field on the QBE grid. the Run icon to run the query If your is correct, you will see the following dynaset. Name the query, State Sort Query. You can also sort the information you display on your list using two fields for the sort order. For example, you can sort the list in ascending order by city, and then by state. The main sort has to be to the left of the minor sort. Therefore, because we want to sort by State first and then by City, we must show the sort in the order below. Notice, we are only sorting with the second City field. We are not showing that City field in our list. Field ClientID FirstName LastName City City Table Client Client Client Client Client Sort Ascending Ascending Show x x x x x Criteria Or Or Now, let’s try it. Click on the Create Tab, and then click on the Query Design Icon to display a new Query By Example (QBE) Grid. Double click the Client table selection and then click the Close Button Double click on the ClientID, FirstName, LastName, City, State, and then add the City field again to add them to the grid. Add Ascending in the sort row underneath State field on the QBE grid. Add Ascending in the sort row underneath the second city Field on the QBE grid. Take off the show checkmark on the last City field on the QBE grid.
CSE%201111%20Pre%20Lab%209%20Revised.docx