Microsoft Access 2007 tutorial:filter data

Filter Data

V. Filter data

You can retrieve data conditionally from a table or query by using the operators listed below:

Operators Descriptions Examples
= Equal condition ProductName='ANCHOR'
< Less than condition Quantity<50
<= Less than or equal to Quantity<=50
> Greater than condition Quantity>30
>= Greater than or equal to Quantity>=30
<> Opposite or not equal to condition ProductName<>'ANCHOR'
And Combining conditions and it returns true if all conditions are true Quantity>20 and UnitPrice<15
Or Combining condition and it works if which condition is true Quantity>20 or UnitPrice<15
Like Matching a pattern condition ProductName Like'C*'
Between Determine the values between value1 and value2. See the example on the right UnitPrice Between 12 and 20
In Matching a collection of values ProductName In('ABC','ANCHOR')
Not Opposite condition Not Quantity>25
Is Null Motoring Null value Address Is Null

Example1: show all female students. To do so, see the figure:

Microsoft Access 2007 equal to operator

Example2: show products that have quantity greater than fifteen. To do so, see the figure:

Microsoft Access 2007 greater than operator


This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.