Ampersand (&) imbedded in Field Name turning into an operator erro

[Guest]

I have a field name that has an ampersand in it [BUS&HTWT],
I know, I know, this is a big no-no, but this is how the database came to me,
and I'm not about to reverse engineer the whole thing.
Here is my dilemna:
whenever I try to go into Design View of an Append query, the
ampersand-imbedded-fields "append to" field always reverts the ampersand part
of the field name to an operator and splits up my field name in two [BUS] &
[HTWT] instead of [BUS&HTWT]. I have to fix it every time I go into Design
View by erasing the spaces and saving it again. Is there anyway around this
Automated Microsoft AI Voodoo?

 

[Guest]

Kou,

It's unclear why you can't rename it at the table level, but you could
create a query with a new name, and base subsequent Append queries on it
rather than the table directly.

SELECT BUS&HTWT As NewName;

Sprinks