You CAN sort by multiple fieds in a table, although as mentioned, this is
not common practice. To sort by multiple fields in a table, use your cursor
to select the fields headers of the columns you want to sort by. Then click
the A/Z button.
You'll need to make sure the fields you want to sort by are next to each
other. Access won't let you select fields separated by other fields. To
move a field temporarily for sorting, select the field header, then use drag
n drop to put it next to the other fields you wish to sort by. Hard to
explain in text :|
Hope that helps
