Brackets in the Append To row of an Append Query

  • Thread starter Thread starter DDogCap
  • Start date Start date
D

DDogCap

I have a table that I copy and then want to append the original table to it
giving a new table with doubles of everything.
I copy the table then, I create a query using query wizard. I choose all
fields in my table. Then name it and go to Modify. I change it to an append
table and choose the copied table mentioned above. At this point, all of the
fields listed on the "Append To:" row have brackets around them the Append
Query doesn't run correctly. I have to manually strip the brackets from this
row and then the query works fine. Thoughts?
 
The error I get is "The INSERT INTO statement contains the following unknown
field name: '[categoryid]'. Make sure you have typed the name correctly, and
try the operation again."

[categoryid] being the first field in the query.
 
Ahh yes, much cleaner. However my table name has two words, "Gas Inventory".
What's the proper syntax? I've tried Quotes and brackets but it can't find
the table.
-Galen
 
Back
Top