Update table using Query Filter

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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

Counting multiple memberships 1
Delete record in a join query 1
AVG crosstab query with one field containing text 7
Update Query using Table & Query 3
Updateable Query 2
cross tab query outer join 1
Delete Query: Could not delete from specified tables 0
Make table query: [Enter 1] AS Test 1

Back
Top