asi
asked on
Sql Access
how do i write query with fields that has blank in the name
for example
There is field named "Field 1"
select * from Table1.Field 1 --- ??
for example
There is field named "Field 1"
select * from Table1.Field 1 --- ??
select * from table1.[field 1]
try this
select "Field 1" from TheTable
meikl ;-)
select "Field 1" from TheTable
meikl ;-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so , why do i get error on
INSERT INTO Table1([Field 2]) VALUES ('1')
INSERT INTO Table1([Field 2]) VALUES ('1')