Update query is not working - stumped

norwoodkd2001

New Member
Joined
Jun 30, 2015
Messages
10
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?:confused:

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

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,630
Office Version
2013
Platform
Windows
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] ;
 
Last edited:

norwoodkd2001

New Member
Joined
Jun 30, 2015
Messages
10
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,442
Messages
5,450,479
Members
405,613
Latest member
Arpit

This Week's Hot Topics

Top