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:
Click anywhere in the field on ...
Get Ten Minute Guide to Access 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
