How to refer to an existing field name containing an illegal chara

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write an append query for an existing table and don't have
rights to change the table design. The field name is "S&H" (Really!) (My
quotes).

Have tried enclosing the field name in [square brackets] and "quotes", but
no dice.

Going nuts! HELP! How do I refer to this field?
 
I create a table with this field name and I had no problem appending to it

S&H

Or, event field name "S&H" (with quote)

Can you post your SQL?
Is that running a query or SQL through code?
 
Back
Top