field / column alias versus field captions

[highandwild]

Hi All

I want to use a field / column alias in a query, as this is what an exported .cvs file needs, but the field caption, as set up in the table properties, is being used instead of the field / column alias I specify in the query.

Does anybody know of any way around this?

I can append the data to a temporary table with the right field / column names if there is no solution.

I don't usually have to contend with field captions as I don't use them in my databases.

Thanks

 

[highandwild]

I do use that method but where one is using a set of tables where the developer has used Field Captions for many of the fields then it is not possible to do that.

It still appears that the Field Caption takes precedence over the Field Alias.

 

[highandwild]

Thanks for your response Pat.

I am quite able to do any coding necessary so will create a temporary database and table and then link to it.

It does seem that the people that developed Access made some weird decisions.

BTW - I have a Backend Database and Frontend Database and link to the table in the BE in a setup routine run at startup. I unlink the tables when the system is closed. Does this linking and unlinking add bloat to the FE.

Thanks