Update table using Query Filter

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AVG crosstab query with one field containing text 7
Update Query using Table & Query 3
sum field from one query to update a field in a table 2
Make table query: [Enter 1] AS Test 1
Recordset not updateable 3
Update query 2
Updateable Query 2
Help! Need to update linked SQL table in Acc07 3

Top