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

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

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