Microsoft KB Archive/95573

{|
 * width="100%"|

PRB: Error Message: Query Must Have at Least One Output Field
'Article ID: Q95573

Creation Date: 17-FEB-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access version 1.0

SYMPTOMS

When you try to execute a query, you receive the following error message even though the query clearly has fields in the query grid:

Query must have at least one output field CAUSE

One of the fields in the query grid has a colon as the right-most character in its name (for example, LastName:). The query parser looks for colons in a name to denote calculated fields and misinterprets the field name as a result.

This happens only if the field name with the colon is the only field or if all fields have colons.

RESOLUTION

Open the source table in Design view and remove the colon from the field name. Changing the field name does not affect the data stored in the field.

-or- Place square brackets around the field name in the query grid. STATUS

This problem does not occur in Microsoft Access version 1.1.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00

KBCategory: kbusage

KBSubcategory: QryOthr