arrggh- update query driving me bonkers!

[dubmunkey]

Hi all,

im having trouble with an update query wher i need to update one field [class] of a table [txStudents] from an existing query Newfacility_Students where the StudentId in [txStudents] matches the StudentId in Newfacility_Students

thought it would be simple enough


UPDATE txStudents
SET Class = Newfacility_Students.class
WHERE ((StudentId = Newfacility_Students.StudentId));

it's not working it says it prompts me for this Newfacility_Students.class
but when i add that table to the design view it messes up the syntax in the sql view

UPDATE txStudents Newfacility_Students
SET Class = Newfacility_Students.class
WHERE ((StudentId = Newfacility_Students.StudentId));

any ideas?

im going crazy!!

dubs

 

[Brianwarnock]

If I understand you correctly where's your join? Have you read Access help on update queries?

Brian