How can I filter data on access?

Asked By William Gonzalez 10 points N/A Posted on - 04/08/2012

Hi,

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

Waiting for your help. Thanks.

• Status: Open
• Question Views: 924
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Theophil Keth 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.

About Theophil Keth

Questions
1

Answers
21

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 04/13/2012
• Question Category: MS Access