MSQUERY: Error Entering Criteria with Add Criteria Dialog

 Last reviewed: September 12, 1996
Article ID: Q139419
The information in this article applies to:
  • Microsoft Query for Windows, version 1.0

SYMPTOMS

In Microsoft Query, you may receive an error message similar to the following when you add criteria in the Add Criteria dialog box: 

   Syntax Error

CAUSE

This problem occurs when you use various third-party Open Database Connectivity (ODBC) drivers. The following ODBC drivers are known to display this behavior: 

   DEC Rdb, versions 1.x and 2.0
   IBM DB2

RESOLUTION

You can use an alternate method of entering criteria to avoid this problem. This method requires you to specify the criteria information directly in the Criteria Pane. To do this, use the following steps:

  1. If the Criteria Pane is not visible, choose Criteria from the View menu.

  2. Select a cell in the Criteria Field row, type the name of the field to which you want to apply criteria, and press ENTER.

NOTE: You can also specify criteria by clicking a Criteria Field cell, clicking the down arrow in the cell, and selecting the field in the list. You can also drag a field name from the appropriate table in the Table pane.

RESOLUTION

The DEC/Oracle ODBC driver for Rdb, version 2.0-A, corrects this problem. This driver is available from your Oracle Sales Representative.

MORE INFORMATION

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

KBCategory: kbtool kb3rdparty
KBSubcategory: xlquery

Additional reference words: 1.00 2.0a 2.00a



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.