Modify Titles of Query Fields (1 Viewer)

[jcbhydro]

Good Afternoon,

I have a simple Query which very satisfactorily exports data to a Tab Delimited Text File to upload to a website.

The field titles are dictated by the Table Field Names but I would like to modify these for the export. Is there a simple criteria code by which this can be achieved.
Any suggestions would be welcome.

Regards,

jcbhydro

 

[plog]

No criteria, but you can use aliases:

Name: cust_Name
Birthday: cust_DOB


In the query, type what you want it to be named, put a colon after it and then the field name.

 

[jcbhydro]

Please excuse my ignorance, but where exactly does one insert the alias?

jcbhydro

 

[David R]

On the Field line, at the top of Query Design View. Ever seen it name a column "Expr1"? That's an alias.

http://office.microsoft.com/en-us/training/show-or-hide-your-fields-RZ010359157.aspx?section=6

 

[jcbhydro]

Thanks for that.
The solution works well for most of my aliases, but some of my needs create problems.
For instance, a couple of my upload demands involve a full stop,
ie Book Ref.:BOOKREF. Is it possible to achieve such an alias?

I also have a couple of instances in my query which also cause problems;
Signed:SIGNEDYN:Iif([Library].[SIGNED],"Yes","No")

My various attempts have failed to achieve success.

jcbhydro

 

[David R]

I don't fully understand your first question. Yes it is possible to put this at the end of a field:

& "."

For your second, you're not asking it a question... what values can [SIGNED] have?

Signed:SIGNEDYN:Iif([Library].[SIGNED]="Y","Yes","No")

maybe?

 

[Keith Tedbury]

Is the Signed:SIGNEDYN meant to be alias for the field.
If so you will need to put it in quotation marks so

"Signed:SIGNEDYN":Iif([Library].[SIGNED],"Yes","No")

It uses the : to distinguish between the alias and the field, 2 of them confuses it if you don't have the quotation marks

 

[David R]

Good catch Keith.