Append Query Field Name Problem

[gthull644]

When I produce an append query that has field names such as 2007/08, the field name is truncated to 2007/8, which results in the query failing. SQL:

INSERT INTO [tblTemp Input] ([2007/08], [May-07]

Becomes:

INSERT INTO [tblTemp Input] ([2007/8], [May-7]

when the query is saved and re-opened.

I could rename the fields of the source table but is there an easier solution?

I am using Access 2003.

 

[ajetrumpet]

gthull,

I wonder if putting " " marks around these number strings would help??

In the future, I would avoid using mathematical symbols in field names, as this might cause you more headaches when using other Access tools or even when you refer to these names.

(Access converts your SQL into the processing format it prefers, even when you've written it correctly.)

 

[boblarson]

This just shows - another good argument for naming fields and objects WITHOUT special characters (and you shouldn't use spaces or reserved words either).