square brackets in append query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Franklin - 18 Feb 2008 18:31 GMT

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

Reply to this Message

Duane Hookom - 18 Feb 2008 21:35 GMT

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

Signature

Duane Hookom
Microsoft Access MVP

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message