The information in this article applies to:
SYMPTOMSIn Microsoft Query, when you add criteria to a query created using SQL Server data source, you receive one of the following error messages:
-or-
CAUSE
This behavior occurs when you add criteria to a query for a Bit field, Text
field, or an Image field, AND you also add criteria for a grouped field.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in in the version of Microsoft Query that ships with Microsoft Excel version 5.0c for Windows. MORE INFORMATIONYou can group records in a query by selecting the Group Records check box in the Query Properties dialog box, or by displaying totals for a field. Both of these operations create the GROUP BY clause in the SQL statement. The GROUP BY clause combines records with identical values in the specified field list into a single record. REFERENCESFor more information about Data Types (Advanced), choose the Search button in Help and type: image data type Additional query words: err msg
Keywords : xlquery |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |