Placing ":" (Colon) In Field Header

I have a query with a field name of "Street", however, I would like
it
to read "CAT:STREET".

This query is exported to a csv file that requires the format of the
later. Currently the csv file is modified manually after the fact.
In the query I have been unable to create an expression that does not
choke on the ":". Or is there a way to add the Header Field Name at
the time of the TransferText?

Any suggestion as to how allow this in the query, or maybe allow this
in the export.

Thanks in advance

Re: Placing ":" (Colon) In Field Header

Switch the query to design view, and enter the alias for the field name in
square brackets.

This kind of thing:
SELECT Surname, Street AS [Cat:Street] FROM MyTable;

Can't say I really recommend this. Access is likely to get confused at some
point with the colon in the name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Clint Stowers" wrote in message
news:1193270821.599586.53830@z24g2000prh.googlegroups.com...
>I have a query with a field name of "Street", however, I would like
> it
> to read "CAT:STREET".
>
> This query is exported to a csv file that requires the format of the
> later. Currently the csv file is modified manually after the fact.
> In the query I have been unable to create an expression that does not
> choke on the ":". Or is there a way to add the Header Field Name at
> the time of the TransferText?
>
> Any suggestion as to how allow this in the query, or maybe allow this
> in the export.
>
> Thanks in advance
>

Re: Placing ":" (Colon) In Field Header

Sorry: switch the query to SQL View to make the change.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Allen Browne" wrote in message
news:4720169b$0$30576$5a62ac22@per-qv1-newsreader-01.iinet.n et.au...
> Switch the query to design view, and enter the alias for the field name in
> square brackets.
>
> This kind of thing:
> SELECT Surname, Street AS [Cat:Street] FROM MyTable;
>
> Can't say I really recommend this. Access is likely to get confused at
> some point with the colon in the name.
>
> "Clint Stowers" wrote in message
> news:1193270821.599586.53830@z24g2000prh.googlegroups.com...
>>I have a query with a field name of "Street", however, I would like
>> it
>> to read "CAT:STREET".
>>
>> This query is exported to a csv file that requires the format of the
>> later. Currently the csv file is modified manually after the fact.
>> In the query I have been unable to create an expression that does not
>> choke on the ":". Or is there a way to add the Header Field Name at
>> the time of the TransferText?
>>
>> Any suggestion as to how allow this in the query, or maybe allow this
>> in the export.