It sounds like you need to use an update query. Open a new query in design view based on the table where the data is stored. Under Query in the menu bar, choose "Update Query". You can enter in selection criteria to determine which records to update, and there is a row for you to enter the new value.