Overriding table caption in query

  • Thread starter Thread starter Marty R.
  • Start date Start date
M

Marty R.

I've searched the heck out of this and can't find an answer to what seems
would be a simple question! I'm querying a table that has captions for
fields and the caption is overriding my column alias. So, FieldName AS
NewColumnName should display NewColumnName but instead displays
Tablename.FieldCaption. If I run a new query off the query, NewColumnName is
displayed, but that seems extraneous.

TIA.
 
If presentation is important to you (which clearly it is) you would be well
advised to use a form to display the query results. Then you will have
maximum control over presentation.
 
Back
Top