Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Getting the default value.. Please respond!

Author  Topic 

acex10
Starting Member

13 Posts

Posted - 2005-01-05 : 03:15:26
sqlstr2 = "Alter Table Statistics Add Campaign_A_Imp Number Set Default 0, Campaign_A_DateShowed DateTime, Campaign_A_LinkID Number, Campaign_A_NumClick Number, Campaign_A_DateClicked DateTime"

How do I set the default value of Campaign_A_Imp to 0 when create the col of dataType number in ms Access?
   

- Advertisement -