How do I refer to existing field name that has an illegal characte

[Guest]

An existing table to which I must append records has a field named "S&H"
really. I am not allowed to change field names in this table.

I've tried enclosing the name in [square brackets] and "quotes" with no
success.

How do I refer to an existing field name that has an illegal character in
it?

 

[John W. Vinson]

An existing table to which I must append records has a field named "S&H"
really. I am not allowed to change field names in this table.

I've tried enclosing the name in [square brackets] and "quotes" with no
success.

How do I refer to an existing field name that has an illegal character in
it?

Try S&&H - two & characters to get one.

What's the context? a SQL query?

John W. Vinson [MVP]

 

[Guest]

Success! Thanks very much.

I'm using the query design grid, appending records to table1 from the
results of a select query, query_results1. So I have to name the columns of
query_results1 to match the field names of table1. And one of the fields
in table1 is 'S&H' (if you can believe it!).

An existing table to which I must append records has a field named "S&H"
really. I am not allowed to change field names in this table.

I've tried enclosing the name in [square brackets] and "quotes" with no
success.

How do I refer to an existing field name that has an illegal character in
it?

Try S&&H - two & characters to get one.

What's the context? a SQL query?

John W. Vinson [MVP]