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

Use the ANSI SQL data type BIT as in:

ALTER TABLE TargetSelect ADD COLUMN TransSelect BIT

(Yes/No is the Access SQL synonym for the ANSI SQL data type).

Bob

Hi Bob
Thanks for your response. It worked well.
Regards
Liz