Q+E Err Msg: More Than One Field Has This Name...

Last reviewed: November 3, 1994
Article ID: Q69524
Summary:

The error message "More than one field has this name: {field_name}" (where {field name} is the name of your field) can appear when you try to save a set of mailing labels in Q+E.

This indicates that two fields from a query have the same name. To correct this, choose SQL Query from the Select menu and modify the query to include only one set of common names.

More Information:

The mailing label option under Save As... does not have the capacity to distinguish between two fields with the same name, even if the filename identifier is attached to the beginning of the field.

In most cases, the message indicates that two databases have been joined and one of the fields to be printed was in both databases. When a "join" is performed, Q+E includes all fields by default. The query window keeps the duplicate fields separate by attaching the database filename to the beginning of the field. By modifying the SQL Query, you can remove one of the fields from the query.

Example

   SELECT EMP.FIRST_NAME, EMP.LAST_NAME, EMP.EMP_ID, HIRE_DATE,
   SALARY, DEPT, EXEMPT, INTERESTS, ADDR.FIRST_NAME, ADDR.EMP_ID,
   STREET, CITY, STATE, ZIP
   FROM C:\EXCEL300\QE\EMP.DBF, C:\EXCEL300\QE\ADDR.DBF
   WHERE EMP.LAST_NAME = ADDR.LAST_NAME

This is an example of a join, using the sample files EMP.DBF and ADDR.DBF, where the LAST_NAME fields are identical. Notice that there are three fields that have the same name. Because the join was being performed using the LAST_NAME field, Q+E was able to leave the ADDR.LAST_NAME field out. However the FIRST_NAME and EMP_ID fields are duplicated in the query. If either of these fields are used in saving mail labels, it will generate the error message.

To correct this query, remove the ADDR.FIRST_NAME and ADDR.EMP_ID.

Note: This problem still occurs in Excel for OS/2 version 3.0.

Reference(s):

"Q+E for Microsoft Excel User's Guide," version 3.0, pages 29-31 and 33-36


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.5 2.50 3.0 3.00


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: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.