Alter Table - Add Column
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?