hello,

i just added a new column b (text) to a table tbl(a).

how do i assign a given value "default" to existing records in the table, for column b?

thanks

Use an update query for the existing records

Create an update query to populate the field. Then if you want a default value for every new record then set this in the table properties.

David

doh, the easiest solution.

i was thinking about some obscure access functions i don't know of:)

thanks