View Single Post
  #1 (permalink)  
Old July 28th, 2003, 09:16 AM
liz@trinityholdings.co.za liz@trinityholdings.co.za is offline
Registered User
 
Join Date: Jul 2003
Location: Cape Town, , South Africa.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Alter Table - Add Column

Hi
Can anyone help. I am trying to use the 'Alter Table' statement to add a column to a table. The column I need to add is a Yes/No data type:

ALTER TABLE TargetSelect ADD COLUMN TransSelect Yes/No

Access doesn't seem to accept the data type 'Yes/No' so I just get a syntax error. Any suggestions?
Thanks
Liz


Reply With Quote