ezfriend Registered User. Local time Today, 11:32 Joined Nov 24, 2006 Messages 242 Apr 29, 2009 #1 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
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 Registered Lunatic Local time Today, 11:32 Joined Aug 27, 2008 Messages 3,514 Apr 29, 2009 #2 ALTER TABLE [tblName] ADD COLUMN ReviewComplete YesNo
pbaldy Wino Moderator Staff member Local time Today, 11:32 Joined Aug 30, 2003 Messages 36,268 Apr 29, 2009 #3 Close; you want YESNO.
ezfriend Registered User. Local time Today, 11:32 Joined Nov 24, 2006 Messages 242 Apr 29, 2009 #4 Thank you both.