Question

How is sorting done in MS Access?

don't copy

don't spam

Answer 1

HEYA!!!

HERE IS YOUR ANSWER,

> The easiest way to do this would be as follows:

> Select the form control containing the data field you wish to sort on by clicking on either the column’s field name at the top of your table or, if you are using a form, clicking on the control where you enter the desired field’s data on the form itself.

> Under the Home tab of the Access ribbon, find the set of options labeled “Sort & Filter.”

> You’ll find two symbols at the left, one with an “A” over a “Z” with a down arrow next to it (Ascending), and the other with a “Z” over an “A” and an arrow (Descending).

HOPE IT HELPS YOU,

THANK YOU.☺️

Answer 2

To sort data of a particular field open the table Performance Report in the Datasheet view and follow the steps given below -:)

⏩Select the column on which you wanted to sort the data and clear the arrow to the right of that column header.

⏩ Click sort A to Z if you want to sort in alphabetic and numeric ascending order and sort Z to A if you want to sort in alphabetic or numeric descending order.

⏩If you want to remove the sorting click Remove Sort button in the Sort and Filter group of buttons on the Home Tab.