I have an access database hooked up to some sharepoint lists. When I query on the ID field in the projects list, like this:
Select Projects.ID As [Project ID]
the query's column heading is "ID", but I wanted to assign the alias [Project ID]. If I query on this new query, I can select newquery.[Project ID] but the column heading is still "ID"!
How can I make the colum heading show my desired alias???