In Access XP sorting records may seem confusing at first. This free lesson offers step-by-step instructions.
Multi-field sorting allows you to define multiple fields in your sort. You specify the column to sort by, (e.g., Last Name), and within that column sort by some other specified field (e.g., First Name). For example, you could sort all of the Brown records by first name.
Moving a column in Access is similar to moving a column in Excel. Click in the column heading of one field to highlight the entire column. Then drag the entire column so it sits alongside the other column(s) to be used in the sort.
Multiple field sorts cannot be performed in Columnar or Tabular Form view.