how do I update a subset of a series of records?

[dab1477]

I have a table with 65000 records or Part Numbers. I want to find specific records and update those records.
I believe I have to do the following:
Create an update query that includes the Part Number column and the associated columns to be updated, then using the FIELD row, show the table from where I'm updating the information.
Is this correct, or is there another method? I have done updates to the WHOLE table successfully, but have never done just specific records within a table.

Thanks in advance.

 

[jackd]

The "secret" to using an Update query to update only a specific set of records is the
WHERE clause.
see http://www.w3schools.com/sql/sql_update.asp for a tutorial on Update query.

Pay particular attention to the WHERE clause.