Ms Access 2010 tutorial:filter data


Filter data

V. Filter Data

Sometimes you may want to view the data that equal to something or greater than, less than something or opposite to something. You can filter data conditionally from a table or query by using the operators listed below.

Operator DescriptionExample
=Equal conditionProductName = 'ANCHOR'
<Less than conditionQuantity<20
<=Less than or equal conditionQuantity<=50
>Greater than conditionPrice>40
>=Greater than or equal conditionPrice>=40
<>Opposite or not equal conditionProductName<>'Angkor'
AndCombining conditions and it returns true if all conditions are true.Quanity>20 And UnitPrice <15
OrCombining conditions and it works if which conditions is true.Quanity >20 Or UnitPrice<15
LikeMatching a pattern conditionProductName Like 'C*'
BetweenDetermining the value between value1 and value2 UnitPrice Between 15 and 23
InMatching a collection of valuesProductName In('ABC', 'LOVE')
NotOpposite conditionNot Quantity >20
Is NullMonitoring Null ValueAddress Is Null
 

Ex1: You want to display all female students. To do so, follow the figure below:

Microsoft Access 2010 Equal to operator in query 

Ex2: You want to display the product names starting with C letter.

Microsoft Access 2010 Like operator in query 

Ex3: You want to show the customers that live in Phnom Penh city or Kandal  province.

Microsoft Access 2010 Or operator in query  




Comments




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.