Alter Table With Boolean Fields (1 Viewer)

[ezfriend]

When I run this in Access, I get an error.

ALTER TABLE [tblName] ADD COLUMN ReviewComplete BOOLEAN

What's the proper way to alter table with boolean field.

Cheer.

Thanks.

EZ

 

[SOS]

ALTER TABLE [tblName] ADD COLUMN ReviewComplete YesNo

 

[pbaldy]

Close; you want YESNO.

 

[ezfriend]

Thank you both.