Microsoft KB Archive/40302

From BetaArchive Wiki

Microsoft Knowledge Base

File: Can't Specify More Than One "<>" Field in Find

Last reviewed: October 27, 1994
Article ID: Q40302

Summary:

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

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


Additional reference words:

KBCategory:kbusage
KBSubcategory:


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 27, 1994
©1997 Microsoft Corporation. All rights reserved. Legal Notices.