"Expr 1014" if field of query ?

[BobC]

In attempting to troubleshoot some problems in a query, I noticed that
three of the fields (design mode of Access 2000) showed "Expr 1014",
"Expr 1015","Expr 1016". Data exists in the fields when I execute the
query. What does this mean?

 

[BobC]

Correction: three of the fields (Run mode of Access 2000)

 

[Duane Hookom]

This generally suggests the same field name is used in the design of your
query multiple times. If you can't figure this out, post your query SQL view
and possibly your field names (if you are using SELECT *).

 

[John Spencer]

Duane failed to mention that you could have a calculated field (column) that
was not titled when the field was created. Access will automatically give
these calculated fields an a name of EXPR followed by a number.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..