Overriding table caption in query

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.
 
B

bcap

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datasheet caption for yes/no field can't be changed 1
Caption title is not appearing in caption table 1
Access 2007 query returning field names rather than alias 6
Query - MID function & Mail Merge 2
Counting YES/NO in a Table with a Query 5
Data Not Displayed in Query 2
How to get the "Caption" value for a field in a table. 5
Capture Field Caption from a table 2

Top