Does anyone know if it is possible, when adding a new column to an existing Access table, to pre-fill all the records in that column with some pre-determined data? I appreciate you can pre-fill new records one by one but we need to pre-fill even the existing records. Many thanks in anticipation....