Question:
How do I execute SQL against an Access table that has a
special character in a field name, such as a #? Whenever I
try my statement I get a "General SQL Error".
Answer:
Place [] around the field name. Example:
SELECT * FROM Table WHERE Table.[Phone #] = '(831)431-1000'