Inserting into multible cell

[Intersysop]

How do you insert data down a column? I need to make some database changes, i inserted a new column and i need to insert a default value.

[matthewspatrick]

In the table design you can assign a default value, but that will only get applied to new records. To fix the old records, run a query like:

UPDATE YourTable
SET NewField = 0

or if text:

UPDATE YourTable
SET NewField = "N/A"