assign a value to all records for a field

[laailalalaa]

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

 

[namliam]

Use an update query for the existing records

 

[DCrake]

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

 

[laailalalaa]

doh, the easiest solution.

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

thanks