Is there a way to create a default value for a column when creating a table in ACCESS 2003? the only documentation I can find indicates to use the ALTER TABLE statement, but is there a way to simply assign it when first creating the table? I want the Match column to default to NO. Also, is there a way to tell the process this should also be a checkbox, which by default is no?
strCreateTable = "CREATE TABLE tblTEMPWeeklyApps (Campaign_ID Integer, SSN Text(12), " & _
"Booked Integer, Approved Integer, AppDate Date, Age Integer, " & _
"Reference Text(20), AddrType Integer, DNIS Text(10), AppEID Text(20), " & _
"Match Bit DEFAULT 'No')"