Even th ough you enter your records into the database in some sort of logical order, at some point, you'll want them in a different order. For instance, if we entered the dogs in our kennel according to registration number, we might later want to look at the list according to the dogs' birthdates, from oldest to youngest.
The Sort command is the perfect solution to this problem. With Sort, you can rearrange the records according to any field you like. You can sort in either ascending (A to Z, 1 to 10) or descending (Z to A, 10 to 1) order.
You can sort in either Form or Datasheet view, but I prefer Datasheet view because it shows many records at once.
Follow these steps to sort records:
Click anywhere in the field on ...