SELECT command

[Reality Strikes]

I have an access database with several fields........one of the field is having the field name as "Client#" in table Client_Table. When I'm using this SELECT stattement :

"Select Client#, ClientName, ClientGender from Client_Table".

It's displaying an error : "Syntax error in date in quesry expression 'Client#'". But when I'm not using "Client#" its displaying the other records properly. Thanks in anticipation.

[Harvey Saayman]

is the column name actually "Client#"? if thats the case try this...

SELECT [Client#], ClientName, ClientGender FROM Client_Table

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL

you.suck = (you.passion != Programming)

[Reality Strikes]

Many many THANKS for that..........it did worked..........thanks.

[Harvey Saayman]

Its a pleasure :)

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL

you.suck = (you.passion != Programming)