Caption Property & Queries

[jhrBanker]

How can I change the name of a Field in a query when the Caption Property has been set for the field in the underlying table? For example, table tblTest has a field named "Company Number". The Caption Property for this field has been set to "CompanyNbr". I want to create a query on this table and change the name of the field to "Co". I've tried "Co: [Company Number]", but the field name in the query is "CompanyNbr". I've tried "Co: [CompanyNbr]", but that results in a "Enter Parameter Value" dialog box for "CompanyNbr".

I realize I could simply delete the Caption. However, this is a database I receive weekly from an external source, and it has many fields in it.



This problem occurs in both Access 2003 & 2007.

Thanks in advance for your help.

[dcrake]

If you go to the properties of the field in your query there is one for caption. If you place the text you want to display it superseeds the one in the table definition.

David

[jhrBanker]

That did it! Thanks for your help, and thanks for the quick reply.

[dcrake]

Glad you got it working.

David