Microsoft KB Archive/51007

= Microsoft Knowledge Base =

File: Finding Information
Last reviewed: October 27, 1994

Article ID: Q51007

Summary:

The information below is taken from the Microsoft File version 2.00 Help file for Finding Information but is relevant to all versions of File.

More Information:

FINDING INFORMATION
After you enter records in the datafile window, you will want to search through the datafile to find records that match certain criteria so you can prepare reports based only on some of the records in your datafile.

To Find Records

 * 1) Choose Find from the Organize menu.
 * 2) Select an insertion point in one of the fields.
 * 3) Type the information you want to find.
 * 4) The find window looks just like the form for the datafile you are using.

To Use Operators
Type one of these operators along with the information you want File to look for:

Operator         Description ---

John             Finds John and Johnson

=John            Finds only John

<>John           Finds Aaron, David, and Johnson

>John            Finds Johnson, Kummer, and Linton

=John           Finds John, Johnson, Kummer, and Linton

<=John           Finds Aaron, David and John

John...L         Finds John, Johnson, and Kummer Use the symbol &quot;*&quot; as a wildcard for matching any number of characters in a certain position. Use the &quot;?&quot; for matching a single character.

Use a comma to specify a series of items to find when you use the &quot;=&quot; operator or no operator.

For example, type John, David to find all records that match &quot;John&quot; and all records that match &quot;David&quot;.

If the information you want to find includes one of the operators or a comma (for example, in Medium date formats), put quotation marks around what you want to find.

For example, type &quot;Sep 6, 1985&quot; to find that one date. Also, you can type =&quot;&quot; to find blank values, or #ERROR* to find error values.

To Hide Records
If there are records you don't want displayed in the datafile window, you can hide them by selecting the records and choosing Hide Records from the Organize menu.

To Display All Records
You can display all the records in the datafile window by choosing Show All Records from the Organize menu.

For more information, see &quot;Finding Information&quot; on pages 91-95 in the &quot;Microsoft File for the Apple Macintosh&quot; version 2.0 manual.