Update table using Query Filter

R

Ripper

I have a large table, tblStudents, that I want to update 1 field using an
update query.

I created a query from a table of grades using a between statement to filter
down to the records that I want. There is an ID number that is the same in
the query and tblStudents.

I use the studentID in the table and link it to the student ID in the query.
I then pull the ID from the query and the field from the table to update and
the query is not updateable.

Is there a way, using the query to filter the table records, to update only
those table records?
 
N

Naeem

put the desired student ID in the criteria section of your update
query. that will filter and only records with matching fields will be
updated.
 
Top