ezfriend Registered User. Local time Yesterday, 22:10 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 Yesterday, 22:10 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 Yesterday, 22:10 Joined Aug 30, 2003 Messages 36,267 Apr 29, 2009 #3 Close; you want YESNO.
ezfriend Registered User. Local time Yesterday, 22:10 Joined Nov 24, 2006 Messages 242 Apr 29, 2009 #4 Thank you both.