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.