Word number 4 is sort. The arguments for sort are the field or fields to use in ordering the records. We’re going to use the customer name to order the customer list in alphabetical order.

Click the Print button and View to see the results:

Some of the customers have multiple records for different cities. If we remove the where filter, the sort would look like this:

The first page of the View then looks like this:

For each Customer, the cities are in alphabetical order.

 

  Page 1 — the basics
  Page 2 — the result
  Page 3 — the FIVE key words
  Page 4 — find
  Page 5 — where
  Page 6 — print
  Page 7 — sort
  Page 8 — chart

Next – chart >