auto fill new field in selected filter

[Marlene Rocha]

I have added a new field to my table
I want to run a filter on like records and fill the new field easily with the same data
In Approach you could go to the worksheet and use the "fill field" command
How do you do this in Access
The replacement command won't work because the field to be filled in empty
Your help is greatly appreciated.

 

[John Vinson]

I have added a new field to my table.
I want to run a filter on like records and fill the new field easily with the same data.
In Approach you could go to the worksheet and use the "fill field" command.
How do you do this in Access?

An Update query. Apply whatever criteria you like, and put the value
to which you want this field set on the Update To line of the query.

 

[Marlene Rocha]

John-
Thank you
I created a new query, adding the field I wanted to fill with the specific data
Selected Update Query and pulled in the new field to be updated (filled with the same data)
Specified the Update To and clicked Run (!)
All went well
Thanks again.