selected field or fields to sort records
Sort Keys
Sort?
You sort them, based on whichever order and field or fields you want.
Sort Key
True
field number
You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.You can import the field that is the primary key, along with all the other fields. As Excel is not really a database program, it doesn't have quite the same facilities to recognise primary keys. You can still use it as the main field to sort the data on, and also specify other fields to sort on.
In Microsoft Access, table sort order is determined by the settings applied to the fields in the table. You can specify the sort order (ascending or descending) in the query design view or in a datasheet view by clicking on the field header. Additionally, you can create custom sorting by using multiple fields, allowing for a prioritized sort based on your requirements. If no sort order is specified, records will be displayed in the order they were entered.
A field that uniquely identifies a particular record in a table is called a primary key. The field or fields on which records are sorted is called the sort key.
Alphabetical order.
In the Fields tab, select a default sort field, choose ascending or descending then click the Save button.
You sort a selected range of cells.