How do you add a field to a MS Access table with a default value in VBA
I need to add a currency field (Freight) to my table (tbl_Quotes). I want to add a default value of 0 in the field so that it is not null. This needs to be done in VBA code. I'm somewhat familiar with the Alter Table command but do not know how to add a default value.