Microsoft Works for Windows Database Instructions

How Do I
Create a filter?
Choose comparison terms?
Show all records?

To filter

Go to tools and choose Filters

You will be asked to name the filter. You can name the filter or click OK to use the default, Filter 1.

Put in information you know to find information that you do not know. Select the field that contains the information you know (For the question, What is the capital of Oman? We know that the country is Oman—so we use the country field to create the filter.) Under "Field name", click on the down triangle to show a list of field names and choose the field by clicking it.  (NOTE: Another way to choose the field name is to click in the box under "Field name" and use the arrow keys to move through the list.  Press enter to choose a field name.)

The comparison in the second part of the filter definition should be chosen with the following guidelines:

Use the number phrases (equal, not equal to, greater than) when your "Compare to" will be a number. The number phrases are the phrases that could be used in number sentence, such as 2/2 = 1, ½ <1, 2>1.
In most cases, use contains as the comparison when the "Compare to" will be a word. Sometimes you can use begins with or does not begin with, but contains is safer.

Put the Compare to in the box on the right. Be sure to spell correctly—you should even be sure not to add an extra space at the end. The filter will not work if this is not exact.

Click on Apply filter or press return.

After you have completed this search, you need to "Show All Records" to see all the records before you can begin a new search (create another filter).

Show all records - Go to Record; choose Show and All Records OR click the Show Records Button on the toolbar.

You can also delete the filter at the Filter definition dialog box.

When you create a new filter (choose Tools, then Filter), you will see the old filter definitions. You can delete the filter or just change the information to meet your new definitions.

<< Previous   Table of Contents  Next >>

Last edited 5/29/01