Page 251 - IT_V1.0_Class10
P. 251
Setting Multiple Fields Criteria
Perform the following steps to use multiple field criteria:
Step 1: Create a query in Query Design window based on the following table:
Step 2: Set the criteria in different fields. In this case, we have set the criteria in two fields Price is <10000
and ID is S02.
Step 3: Save the query with the name Acc_Query. When you execute Acc_Query, you will get the result as
shown below:
2
Using Wildcards
Wildcard characters are used to retrieve a particular record from a table that contains a specified character.
LibreOffice Base provides two wildcard characters * and ?. The * wildcard represents one or more characters.
On the other hands, the ? wildcard represents only one character.
Perform the following steps to use the wildcard characters:
Step 1: Create a query in Design view based on the ACCESSORIES table used in the preceding topic.
Step 2: Use the wildcard character to retrieve name of the products that starts with the letter LIKE ‘M*’.
Step 3: Save the query with the name Accessories_Query. When you run Accessories_Query, you will get
the following output:
2
Queries in Base 249

