Using a . in the column name

[Me]

Hi all.
I want to use "select x as [a.b.] from mytable"
But the name is not accepted.
How do I allow the usage of dots in the column name??
TIA
Guy

 

[Ken Snell [MVP]]

More important question: why do you want to do something that will only
confuse ACCESS and possibly give you very wrong results -- even if you could
force ACCESS to accept something that is the wrong syntax?

Accept the error message you get from ACCESS, and change your naming
convention. See these Knowledge Base articles for more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763

 

[Chris Newman]

simple. dont use predios in column names. its going to mess things up

 

[Me]

OK, I got the point
I just wanted to use initials as a column name...
Guy

simple. dont use predios in column names. its going to mess things up

Hi all.
I want to use "select x as [a.b.] from mytable"
But the name is not accepted.
How do I allow the usage of dots in the column name??
TIA
Guy

 

[Ken Snell [MVP]]

Replace period with underscore... will serve a similar purpose and it's
accepted by ACCESS

a_b_

;-)


--

Ken Snell
<MS ACCESS MVP>

OK, I got the point
I just wanted to use initials as a column name...
Guy

simple. dont use predios in column names. its going to mess things up

Hi all.
I want to use "select x as [a.b.] from mytable"
But the name is not accepted.
How do I allow the usage of dots in the column name??
TIA
Guy

 

[david epsom dot com dot au]

I just wanted to use initials as a column name...

??? But don't let me stop you: open the query in design view, select the
field, and enter the column 'name' into the 'caption' property.

(david)

OK, I got the point
I just wanted to use initials as a column name...
Guy

simple. dont use predios in column names. its going to mess things up

Hi all.
I want to use "select x as [a.b.] from mytable"
But the name is not accepted.
How do I allow the usage of dots in the column name??
TIA
Guy