Setting A Value In A Field

[Larry H.]

Hi,
I have Access 2000 and have a table with approx. 350
records in it. I have added a NEW field and wish to set
up a query or whatever it takes to go through the entire
database and set the value of the NEW field in each
record to a DEFAULT value.

Is there a way to accomplish this?

Thanks,
Larrry H.

 

[fredg]

Hi,
I have Access 2000 and have a table with approx. 350
records in it. I have added a NEW field and wish to set
up a query or whatever it takes to go through the entire
database and set the value of the NEW field in each
record to a DEFAULT value.

Is there a way to accomplish this?

Thanks,
Larrry H.

Larry,
You could do this using an Update query.
Update YourTable Set YourTable.NewFieldName = ...... ;

Replace the Table and Field names with the actual names.
Replace ..... with whatever the value is to be.
If it is a Text datatype field, place the value within double quotes,
i.e. "Chicago".