In an Access query, how can you list records in A-Z order by last name?
A)Set an ascending sort order on the LastName field.
B)Group the LastName field.
C)Set a descending sort order in the LastName field.
D)Remove the checkmark from the Show box in the LastName field.

Question

Quizplus · Accepted Answer

Setting an ascending sort order on the LastName field arranges the records alphabetically from A to Z by last name, which is the correct way to list records in the desired order.

In an Access Query, How Can You List Records in A-Z