How can I filter data on access?

Asked By 10 points N/A Posted on -


I am using Microsoft access 2010. Can you teach me how to filter data on MS access 2010?

Waiting for your help. Thanks.

Answered By 5 points N/A #103642

How can I filter data on access?


There's several ways you can use if your list of records have fields that are empty in a column, by either filtering the list to give you the empty fields only or the non empty field. First, you will need to decide which column you will use.

  • To obtain the records with the empty fields, either right click the column and select equal bank or click an empty cell under the column header, in the sort and filter section of the ribbon, click on Selection and select equal blank, this will display the records with empty fields only.
  • To get the records with non empty fields, you can either Right-click an empty cell in choosing column and click Does Not Equal Blank or Click any empty cell under the column header, in the Sort and Filter section of the Ribbon, click Selection and select Does Not Equal Blank, the table or query will display the non empty records only in that column.

Login/Register to Answer

Related Questions