ACC: ORDER BYs Must Be Output Columns in DISTINCT QueriesLast reviewed: May 28, 1997Article ID: Q96895 |
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1, 2.0, 7.0
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. If you create a query and use the DISTINCT predicate in conjunction with the ORDER BY clause, the fields that are being ordered must be output columns. If the ORDER BY fields are not output columns, you may receive the following error message:
ORDER BY clause ([Table Name].[Field Name]) conflicts with DISTINCT. RESOLUTIONUse the DISTINCTROW predicate or remove the specified field from the ORDER BY clause.
MORE INFORMATION
Steps to Reproduce BehaviorFollow these steps in the sample database NorthWind (or NWIND.MDB in versions 1.x and 2.0):
REFERENCESFor more information about using SQL predicates, search for "DISTINCT," and then "ALL, DISTINCT, DISTINCTROW, TOP Predicates (SQL)" using the Microsoft Access for Windows 95 Help Index. |
Keywords : kbusage QryOthr
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |