View Single Post
  #2 (permalink)  
Old July 28th, 2003, 11:55 AM
Bob Bedell Bob Bedell is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

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
Reply With Quote