Setting A Value In A Field

  • Thread starter Thread starter Larry H.
  • Start date Start date
L

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.
 
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.
Click to expand...

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".
 
Back
Top