Using a . in the column name

  • Thread starter Thread starter Me
  • Start date Start date
M

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
 
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
 
OK, I got the point :)
I just wanted to use initials as a column name...
Guy

Chris Newman said:
simple. dont use predios in column names. its going to mess things up

Me said:
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
Click to expand...
Click to expand...
 
Replace period with underscore... will serve a similar purpose and it's
accepted by ACCESS

a_b_

;-)


--

Ken Snell
<MS ACCESS MVP>

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

Chris Newman said:
simple. dont use predios in column names. its going to mess things up

Me said:
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
Click to expand...
Click to expand...
Click to expand...
 
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)

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

Chris Newman said:
simple. dont use predios in column names. its going to mess things up

Me said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top