![]() |
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