Update query is not working - stumped

[norwoodkd2001]

I have a table called Score which has records of individuals scores for a certain requirement presented by a vendor. The list of requirements is in another Table called Requirements. In the Score table we have entered a Requirement ID that corresponds to the requirement in the Requirements table.

Both tables have the Requirement ID which is what I am using to select the correct record.

I am running this update query but nothing is updating in the Score.Requirement field. What am I doing wrong?

UPDATE ScoreINNER JOIN Requirements ON Score.[Requirement ID] = Requirements.[Requirement ID]
SET Score.Requirement = [Requirements]![Requirement];

 

[xenou]

Normally the thing to do is inspect the results with select and see what you are getting on the joins:

select *
FROM
Score INNER JOIN Requirements
ON Score.[Requirement ID] = Requirements.[Requirement ID] ;

 

[norwoodkd2001]

Thank you! I realized after looking at all the columns my import from Excel for the Requirements table didn't work correctly. I fixed that problem and all is well.