Hope I have read into your problem correctly?
Try this, design and test a query that retrieves the records that you want to update.
Choose Update query from the Query menu, or click the Update Query button in the toolbar. In the "update to" cell for the field that you want to update enter a desired expression. If you want to change a particular value in a field enter a value in the Criteria cell.