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" <Ab***********@gmail.comwrote in message
news:11*********************@z24g2000prh.googlegro ups.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