ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ms query: renamed column returns with blank heading (https://www.excelbanter.com/excel-discussion-misc-queries/191523-ms-query-renamed-column-returns-blank-heading.html)

Rachael

ms query: renamed column returns with blank heading
 
I have a query using MS Query that groups records together. One of the fields
included in the query is Max(MyTable.CompletionDate). I want to rename that
to "Date Completed".

I changed the SQL to Max(MyTable.CompletionDate) AS "Date Completed" but
when I run the query the field comes back with a blank heading. When I go
back into the SQL, my 'AS "Date Completed" text is gone, replaced by just
'Max(MyTable.CompletionDate) , [next field]...'

Is there a way to get a renamed heading to "stick"??

Thanks!


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com