Alter table using On/Off format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to using Alter table, but have the following code:

ALTER TABLE [Select Lots] ADD COLUMN Use (On/Off); - This gets a syntax
error

ALTER TABLE [Select Lots] ADD COLUMN Use On/Off; - This gets a syntax
error.

Any ideas on how to set this so that I do nto get a syntax error. I have
tried the help files, but I have not figured it out yet.

Thanks.
 
What are you trying to do? AFAIK, there's no such thing as On/Off in Access.
I also suspect that Use may be a keyword, and hence not allowable as a field
name.
 
Back
Top