<div>
I think there is a display name property in Sharepoint lists- maybe that is overriding the alias just as the Caption property would on a field defined in Access?
</div>


I think there is a display name property in Sharepoint lists- maybe that is overriding the alias just as the Caption property would on a field defined in Access?

<div>
<div class="content wysiwyg-content">
Hi experts, <br />
<br />
I have an access database hooked up to some sharepoint lists. When I query on the ID field in the projects list, like this: <br />
<br />
Select Projects.ID As [Project ID]<br />
<br />
the query's column heading is &quot;ID&quot;, 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 &quot;ID&quot;! <br />
<br />
How can I make the colum heading show my desired alias???<br />
<br />
Thanks :) 
</div>
</div>


Hi experts, 

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???

Thanks :) 

Access 2007 - alias not showing in query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.