displaying column headings

[casey]

Does anyone know why my column headings won't show up as desired when using the 'AS' SQL reserved word? Example:
SELECT Quantity AS Qty, ProductDescription AS Description, UnitRetail AS Retail, FROM Parts;
Some will show correctly and others won't.
Thanks

 

[casey]

I've stumbled upon my answer. It seems that I've already assigned a caption value to these fields in my table design. After I changed these captions in the table, I was able to display the headings the way I wanted to through the queries.

 

[John Hazen]

I have seen behavior where the "AS" clause name will take precidence and sometimes the table caption does. The SQL should always override the table's caption, but sometimes doesn't. I have not figured out how Access determines this. If anyone knows, please reply.
John_Hazen@hotmail.com

 

[David R]

Captions are really strange creatures. I had a subform based off a query of a table, and could NOT get the Datasheet view to show the captions I wanted consistently. Sometimes they were the query captions, sometimes the table captions, sometimes the fieldnames. I eventually gave up and changed it to continuous form view.