square brackets in append query

F

Franklin

When I create a query and make it an append query the query wizard asks for
the table to append and then adds the fields in the append to row but adds
square brackets around them and then when I try to run the query complains
about the brackets. Is this fixable other than going through the list and
removing the brackets?

Thanks
 
D

Duane Hookom

Brackets often get added to field names in queries (and elsewhere). What is
the SQL View of your query that generates the error message.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Append Query – Issue with automatically inserted brack 3
Append Queries in 2007 5
Append Query is not working 1
Brackets in the Append To row of an Append Query 2
Append Query Issue 0
How to refer to an existing field name containing an illegal chara 1
prevent redundacy in append query 8
append query and delet query 7

Top