Problem using SELECT statement on Access Column Name

sjbrown · #1 (**permalink**) 11-03-04, 17:27

Im writing a VB program that queries an MS Access db. The column name is CONTACT#. Using the SQL statement...
"SELECT * FROM CLIENT WHERE CONTACT# = '1'"
Produces an error. I cannot change the name of the column name is there anyway around this?

LKBrwn_DBA · #2 (**permalink**) 11-04-04, 08:54

Try this:

Code:

SELECT * FROM CLIENT WHERE [CONTACT#] = '1'

Internet Services

Web Development

Digital Marketing

Consumer Tech