Hello;

I have 100 records in a table with a field that does not have a default value specified. If I specify a default value is there an easy way to have all the records updated with the new value without writing an update query?


-thx

I would probably just do it by hand for 100 records :)
ctr-@ copies the value from the previous record and the down arrow selects the next record (in table view)

or you could try copying into XL, copy and paste the data down and paste back into table.
or just use an update query :)

Peter

is there an easy way to have all the records updated with the new value without writing an update query? It took you longer to formulate this post than it would have taken to open the OBE and create an update query????