strange column names and DataType problems

[Piotr Kurpiel]

Hello,

I am using MS Access 2003 with VBScript. I have quite strange column names
which are: 1,2,3,4,etc... Data Types of the columns are Yes/No and formats
True/False. The first thing I want to do is count rows with True in column
1, then column 2, etc. My query is: "SELECT count(*) AS ile FROM profiles
WHERE 1 = True" It doesn't work. I tried to have it 'True' - the same. When
I list all the values it simply says True or False. Any ideas?
The second thing is inserting a new column of the same type. I have: "ALTER
TABLE profiles ADD 100 -?-" How to declare column 100 to have it as the same
DataType and format as the ones before. I am using 'bit' for the time being,
which is not a perfect solution. Any ideas?

Piotr Kurpiel
Pi***********@cern.ch

[Madhivanan]

Try to avoid having col names as 1,2,3 etc. Instead use One,two,three

Madhivanan

[Tim Marshall]

Piotr Kurpiel wrote:

Hello,

I am using MS Access 2003 with VBScript. I have quite strange column names
which are: 1,2,3,4,etc... Data Types of the columns are Yes/No and formats
True/False. The first thing I want to do is count rows with True in column
1, then column 2, etc. My query is: "SELECT count(*) AS ile FROM profiles
WHERE 1 = True" It doesn't work. I tried to have it 'True' - the same. When
I list all the values it simply says True or False. Any ideas?
The second thing is inserting a new column of the same type. I have: "ALTER
TABLE profiles ADD 100 -?-" How to declare column 100 to have it as the same
DataType and format as the ones before. I am using 'bit' for the time being,
which is not a perfect solution. Any ideas?

Try enclosing the field names in square brackets, ie:

SELECT count(*) AS ile FROM profiles WHERE [1] = True

However, Madhivanan's point should be considered for field names
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me