Microsoft KB Archive/40302

= Microsoft Knowledge Base =

File: Can't Specify More Than One &quot;<>&quot; Field in Find
Last reviewed: October 27, 1994

Article ID: Q40302

Summary:

In Microsoft File, you cannot specify more than one value to be &quot;<>&quot; (not equal to) when using the Find command (unlike &quot;=&quot; [equal to] in the Find dialog box). If more than one value is specified, the error message &quot;Error in Find Text&quot; is returned.

For example, if you want to return all the records EXCEPT the records that contain Washington, California, and Florida in the &quot;State&quot; field, typing &quot;<>WA, CA, FL&quot; returns the error &quot;Error in Find Text&quot;. Only one value after the &quot;<>&quot; can be typed into a Find field.