select query invalid bracketing of name

[B Caple]

In making a select query in Access97, I am pasting field references from the list in the build box (adding several fields), but when I go to view the query it errors with "Invalid bracketing of name '...' The field name shown is correct and the bracketing is as added by the build box, such as [table.field]. Any suggestions?

 

[Joe4]

That is not the correct way to bracket a field. It should be:

![field]

I don't know how the older versions of Access do it, but mine (2002) allows me to select the fields from the build box (click on tables, select table, click on field). This is nice because then I know that it will always work.

HTH

 

[B Caple]

Thanks, you are correct that when using the build window and pasting fields from tables it does bracket as

![field]; but if you paste fields from the query itself they come in as [table.field].
I pasted from the tables list and it did work.
Incidentally, I pasted or built another expression from the query fields and it did work and was in the form [table.field].
Strange?

 

[Joe4]

Yes, very strange. There may be some inconsistencies, especially with older versions.

I often run into trouble when writing code on when to use a "period" and when to use an "exclamation point". I like having the option to select them instead of typing them. It greatly reduces my errors and headaches!