Alter Table With Boolean Fields

ezfriend

Registered User.
Local time
Yesterday, 22:10
Joined
Nov 24, 2006
Messages
242
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
 
ALTER TABLE [tblName] ADD COLUMN ReviewComplete YesNo
 
Close; you want YESNO.
 

Users who are viewing this thread

Back
Top Bottom