The Field Properties Window contains the Field Name, Data Type and Description for each field. Data Type is shown as text by default. This is done by making it a primary key . Select the Primary Key icon from the toolbar . If we enter more than one piece of criteria in different columns e.g. as shown, we will narrow the search by looking for records in Cobbold AND more than 4.5 mi away .
All sorts are only temporary.
The underlying table keeps the data in the original format. The best way to have what appears to be a permanent set of records sorted in some way is to create one using a Query.