[Rachael]

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!