Sorting and Filtering A Record In Datasheet View

In this post, we will be showing you how to sort and filter a record in Datasheet view.

Access has an array of filtering and sorting tools which are accessible in the Sort & Filter group on the Ribbon

Let’s put them to use.

Filtering a Datasheet
In order to perform any sorting or filtering actions on a field, you must first click into any record within that field. Here we have clicked into the UnitPrice field of ItemID 1.
Click on the filter button.
A drop down menu will appear. Click on one of the items. We are clicking on Laptop.
The datasheet will now only return records that match the chosen value in the chosen field.
Click on the remove filter icon to remove the filter.

Sorting A Field
Click on the Ascending button in the Sort & Filter group.
The records will now be sorted in ascending order based on the chosen field.
Clicking on the Descending button sorts the records in descending order based on the Description field.
To remove all sorts click on the Remove Sort button.

We hope this has helped you to be able to sort and filter records in datasheet view going forward.

Related Posts