O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting Data

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.

Which View?

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:

  1. Click anywhere in the field on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required